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:

YouTube video
CountA Formula in Excel | MyExcelOnline

DOWNLOAD EXCEL WORKBOOK

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:

value

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

=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

 

HELPFUL RESOURCES:

JOIN OUR FREE EXCEL COURSES BELOW
Click here to access these FREE Excel courses!

 

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