The Klipfolio COUNTNUMERIC function counts all valid numbers and returns the count as a single value.
The syntax for the COUNTNUMERIC function is:
COUNTNUMERIC( data )
COUNTNUMERIC example
Let's look at a COUNTNUMERIC function example.
A |
|
1 | Apples |
2 | Apples |
3 | |
4 | Pears |
5 | 1 |
The following example is based on the above text from an Excel spreadsheet:
COUNTNUMERIC ( A:A )
-> [1]