Different count functions in Excel

COUNT returns the amount of cells in the range which contain a number.

COUNTA (count all) returns the amount of cells containing any value.

COUNTBLANK returns the amount of cells containing no value.

COUNTIF returns the amount of cells in the range which meet your chosen criteria.

 

countfunctions1

Leave a Reply

Your email address will not be published. Required fields are marked *