Search

Learn formula for counting in excel.

COUNT

count in excel

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.

formula excel count
Share this article :
Facebook
Twitter
LinkedIn

Leave a Reply