COUNTNUMERIC function

 

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]

Related links: