CountVal
Counts the number of non-empty cells in a value set.
Syntax
CountVal(param1, param2, ...)NbVal(param1, param2, ...)
param1 = first parameter in the set (value, range, or list)
param2 = second parameter in the set (value, range, or list)
... = nth parameter in the set (value, range, or list)
Remarks
This function accepts an unlimited number of parameters.
If you only want to count non-empty numerical cells, see Count.
To also count the empty cells, see CountCells.
Examples
CountVal(1, "abc") = 2CountVal(A1:B3) = 6 if none of the cells in the A1:B3 range is empty