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:

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

CountA Formula

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