COUNT(<List>) |
![]() ![]() ![]() |
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.
Try Predictive Systems Lab
Need Help?
Contact support