Pinterest Pixel

Count Formula in Excel

What does it do? Counts the number of cells that contain numbers Formula breakdown: =COUNT(value1, [value2]…) What... read more

Download Excel Workbook
Bryan
Posted on

Steps To Follow

Overview

Count Formula in Excel | MyExcelOnline Count Formula in Excel | MyExcelOnline

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:

Count Formula in Excel

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:

Count Formula in Excel | MyExcelOnline

Download excel workbookCOUNT-FORMULA.xlsx

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

=COUNT(

Count Formula in Excel

 

STEP 2: The COUNT arguments:

Table of Contents

value

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

See also  Get the Average of Values with Excel's AVERAGE Formula

=COUNT(C9:C12)

Count Formula in Excel

 

You now have your count of valid numbers!

Count Formula in Excel

 

Count Formula in Excel

 

 

If you like this Excel tip, please share it
Count Formula in Excel | MyExcelOnline Count Formula in Excel | MyExcelOnline
Count Formula in Excel | MyExcelOnline
Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...