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:

How to Combine VLOOKUP and IFERROR to Replace the #N/A Error in Excel

 

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

VLOOKUP with Multiple Criteria in Excel ‘VLOOKUP’ is now so common that everyone who has ever been working with Excel has heard of it. Not necessarily because they know how to use it, but because some savvy Excel-user always talks about it at the office. Advanced users have seen the use of adding more than one...
CountA Formula in Excel What does it do? Counts the number of cells that are non-blank/non-empty (including empty text "") Formula breakdown: =COUNTA(value1, , ...) What it means: =COUNTA(value or range of cells to check, , ...) Do you have a scenario where you want to count the nu...
10 + 1 Ways to Round Numbers in Excel This is a guest post by Alan Murray from Computergaga. There are many ways to round numbers in Excel. These techniques will typically involve formatting the values, or using formulas. This post will look at 10 rounding functions of Excel, and then look at some formatting te...
CountIfs Formula in Excel What does it do? Counts the number of cells that matches your specified conditions Formula breakdown: =COUNTIFS(range1, criteria1, , , ...) What it means: =COUNTIFS(range of cells to check1, condition to check against1, , , ...) Do you have a scenario where ...