COUNTALL function

 

The Klipfolio COUNTALL function counts all numbers, text and blank values and returns the count as a single value.

The syntax for the COUNTALL function is:

COUNTALL( data )

COUNTALL example

Let's look at a COUNTALL 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:

COUNTALL( A:A )

-> [5]

Related links: