Pinterest Pixel

CountA Formula in Excel

What does it do? Counts the number of cells that are non-blank/non-empty (including empty text “”) Formula... read more

Download Excel Workbook
Bryan
Posted on

Steps To Follow

Overview

CountA Formula in Excel | MyExcelOnline CountA Formula in Excel | MyExcelOnline

What does it do?

Counts the number of cells that are non-blank/non-empty (including empty text “”)

Formula breakdown:

=COUNTA(value1, [value2], …)

What it means:

=COUNTA(value or range of cells to check, [value or range of cells to check], …)


Do you have a scenario where you want to count the number of cells that are non-blank or not empty?

I’m sure you do!  There is a simple way to count this with Excel’s COUNTA formula! 

This formula counts everything: numbers, text, non-empty text “”, you name it!

I explain how you can do this below:

CountA Formula in Excel | MyExcelOnline

Download excel workbookCOUNTA-2.xlsx

STEP 1: We need to enter the COUNTA function in a blank cell. Notice there are 6 non-blank cells in here:

=COUNTA(

CountA Formula

 

STEP 2: The COUNTA arguments:

Table of Contents

value

What is the value or range of values that you want to check how many are non-blank?

See also  How to Easily Find Multiples of 16 with Excel Formulas

=COUNTA(B9:C12)

CountA Formula

 

You now have your count of values that are non-blank! There are 6 non-blank values!

CountA Formula

 

CountA Formula in Excel

 

If you like this Excel tip, please share it
CountA Formula in Excel | MyExcelOnline CountA Formula in Excel | MyExcelOnline
CountA 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...