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:

DOWNLOAD EXCEL WORKBOOK

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

=COUNT(

 

STEP 2: The COUNT arguments:

value

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

=COUNT(C9:C12)

 

You now have your count of valid numbers!

 

Count Formula in Excel

HELPFUL RESOURCE:

oztraining_728x90

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

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Division Formula in Excel What does it do? Divides two numbers Formula breakdown: =number1 / number2 What it means: =the number being divided / the number you are dividing by In Excel dividing numbers together is really easy! The Division Formula is done through the use of the div...
Add Comma After the Surname with Excel’s SUB... What does it do? It replaces specific text in a text string i.e. Substitutes new text for old text in a text string. Formula breakdown: =SUBSTITUTE(text, old_text, new_text, ) What it means: =SUBSTITUTE(This cell, From this TEXT character, To this TEXT character, )...
RANDBETWEEN Function for Excel Dates What does it do? Generates random dates, in between a start date and an end date Formula breakdown: =RANDBETWEEN(bottom, top) What it means: =RANDBETWEEN(starting date for random date generation, end date for random date generation)   If you need to ...
Extract Last Name with Excel’s REPLACE Formula What does it do? Replaces part of a text string, based on the number of characters you specify, with a different text string Formula breakdown: =REPLACE(old_text, start_num, num_chars, new_text) What it means: =REPLACE(this cell, starting from this number, all the ...