What does it do?

Counts the number of cells that contain numbers

Formula breakdown:

=COUNT(value1, [value2]…)

What it means:

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

Ever had a column of data and wanted to check if all of the values contain valid numbers?

It would be cumbersome to count and check them one by one, especially if you had hundreds of entries!

Imagine we have the following data, we see an error, a text and a couple of numbers:

Thankfully there is an easy way to count how many of these cells contain valid numbers using the Excel’s COUNT formula.

I explain how you can do this below:


STEP 1: We need to enter the COUNT function in a blank cell:



STEP 2: The COUNT arguments:


What is the value / range of values that you want to check?



You now have your count of valid numbers!


Count Formula in Excel



If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Cleaning Data with Excel’s PROPER Formula  What does it do?Capitalizes the first letter in a text string and any other letters in the text that follow a space. Converts all other letters to lowercase letters.Formula breakdown:=PROPER(text)What it means:=PROPER(this text cell)There are...
Change Phone Area Codes with Excel’s REPLACE Formu... What does it do?Replaces part of a text string, based on the number of characters you specify, with a different text stringFormula breakdown:=REPLACE(old_text, start_num, num_chars, new_text)What it means:=REPLACE(this cell, starting from this number, all the ...
Cleaning Data with Excel’s SUBSTITUTE Formul... What does it do?Substitutes new_text for old_text in a text string.Formula breakdown:=SUBSTITUTE(text, old_text, new_text, )What it means:=SUBSTITUTE(This cell, By this text character, To this text character, )When you needed to replace a specific text...
Count VS Sum in Pivot Tables The #1 complaint that I get from Pivot Tables is "Why do my values show as a Count of rather than a Sumof ?"Well there are three reasons why this is the case:1. There are blank cells in your values column within your data set; or2. There are "text" cells in your value...