Count() Function in Excel

The COUNT function counts the number of cells that contain numbers in a list. It will ignore blanks, Texts and Errors.

Syntax: COUNT(value1, [value2], …)

–> value1    Required. The first item, cell reference, or range within which you want to count numbers.

–> value2, Optional. Up to 255 additional items, cell references, or ranges within which you want to count numbers.

Refer below example:

 

 

 

 

 

 

 

 

 

Practice File for Count() (15 downloads)

Share with your friends and make them awesome in Excel 🙂

Be the first to comment

Leave a Reply

Your email address will not be published.


*