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

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


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

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999