next up previous contents index
Next: COUPDAYBS Up: A. Function Reference Previous: COSH   Contents   Index


COUNT

Syntax: COUNT(argumentlist)

argumentlist = any combination of numbers, cells, or ranges

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

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

Excel function: COUNT


next up previous contents index
Next: COUPDAYBS Up: A. Function Reference Previous: COSH   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003