Learn formula for counting in excel.

COUNT

What Does It Do ?

This function counts the number of numeric entries in a list.

It will ignore blanks, text and errors.

Syntax

'=COUNT(Range1,Range2,Range3... through to Range30)

Formatting

No special formatting is needed.

Example

The following table was used by a builders merchant to calculate the number of sales

for various products in each month.