Count Formula in Excel

It will help you to count the number of cells that contain numbers in your Excel sheet. 

Previously In Excel FormulasHow to Calculate the Compound Interest with Excel’s FV Formula?

Count Formula breakdown:

=COUNT(value1, [value2]…)

The explanation for formula breakdown:

=COUNT(range of cells to check, [additional cells to include in the check]…)

Did you ever want to check if all the values contain valid numbers in a column of data? Checking them one by one can be cumbersome especially if thousands of entries are there.

For example, Imagine I have this data and there’s an error; a text and a couple of numbers following:

Count Formula

Thanks to Excel that it has an easy way (COUNT formula) to count how many of these cells contain valid numbers.

Follow these steps given below to know how to apply this formula to count the number of cells that contains valid numbers:

STEP1: Working With COUNT Function

Firstly, you need to enter the COUNT function in a blank cell of your Excel sheet e.g.:


Count Formula

STEP2: Working With COUNT Arguments

Now continue with the COUNT arguments:


In the place of ‘value’ you need to mention the range of values that you want to check.


Count Formula
There you go with the count of valid numbers