## Count Formula in Excel

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

**Previously In ****Excel Formulas****: ****How 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:

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:

**STEP**1: Working With COUNT Function

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

`=COUNT(`

## STEP2: Working With COUNT Arguments

Now continue with the **COUNT **arguments:

*value*

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

**=COUNT(A2:A6)**