COUNT(<List>)

Top  Previous  Next

 

Description

This function returns a count of its non-blank arguments.  Cells that contain strings are counted.

 

Parameters

 

<List>

Any combination of numbers, cells, or ranges.

 

Examples

 

COUNT("Tom", "Bob", "Sue", "Mary", "Zack", "Ann") = 6

 

COUNT(D4:D8) = 3

Where D4 is empty, D5 = 1, D6 is empty, D7 = 0, and D8 = 5.

 

COUNT(E5:J10) = 30

Where E5:J10 contains 36 cells; therefore, 6 cells are blank.

 

Sponsored

Try Predictive Systems Lab

Interactive Demo →

Need Help?
Contact support