Count and CountA formula in Excel

Learn how to use these Excel FOrmulas on your dataset and its use cases. Also, don't forget to download the practice file. It's easier to use our practice file so you don't have to create one for a business question

Sat Nov 27, 2021

Count Formula

Counts anything in a numerical dataset. Works only for number-based data

Works best on numerical data and returns the output of the number of cells that has data ignoring the cells that are empty.

Realtime Use Case

If you have brought some fruits and only have the prices stored with you. How would you find the total number of purchases? The below example has text and numerical information mixed together.

Formula Syntax

You can select multiple cells from multiple columns or rows. COUNT will include all the selected cells and perform the operation.

Sample Data

Apply the formula on the highlighted cell below and find out the "Number of billionaires"

Copy the formula for ease

=Count(A1:A21)

is-dark-text">

COUNT - Practice Area

Count A

Works best on text data and returns the output of the number of cells that has data ignoring the cells that are empty.

Sample Data

Apply the formula on the highlighted cell below and find out the "Number of billionaires" Copy the formula for ease

=COUNTA(A1:A21)

is-dark-text">

Count and CountA formula in Excel

Count Formula

Realtime Use Case

If you have brought some fruits and only have the prices stored with you. How would you find the total number of purchases? The below example has text and numerical information mixed together.

Formula Syntax

Sample Data

=Count(A1:A21)

COUNT - Practice Area

Count A

Sample Data

=COUNTA(A1:A21)

CountA - Practice Area

You may also be interested in