Formula Engine Reference Guide
 

 

Back to Class Index

 

COUNT(argumentlist)

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

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, E5..J10 contains 36 cells, therefore 6 cells are blank