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]
