EX_Count()

The COUNT function counts all the cells that contain numbers in a specified range.

Try typing =COUNT() to get a return value of 4!

COUNT only counts the cells that contain numbers.

What would =COUNT(A1:A5) return?

Write a COUNT function that counts how many students have at least one pet.

The following table contains Q1 sales. Write a COUNT function to count how many sales people made at least one sale in January.

Write a COUNT function that would count the number of months that Chuck made at least one sale in Q1 (January through March).

Management must calculate a monthly bonus each time an employee makes at least one sale during a given month.

Write a COUNT function to determine how many monthly bonuses must be calculated for Q1.

What would =COUNT(A:B) return?

Write a COUNT function that counts how many students have been absent at least one day.

Based on the Excel spreadsheet , the following

=COUNT(A1:A6) would return:

• 3

• 4

• 5

Based on the Excel spreadsheet , the following

=COUNT(A1:A6, 129) would return:

• 3

• 4

• 5