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:

oztraining_728x90

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

CountIf Formula in Excel What does it do?Counts the number of cells that matches your specified conditionFormula breakdown:=COUNTIF(range, criteria)What it means:=COUNTIF(range of cells to check, condition to check against)Do you have a scenario where you want to count the num...
CountBlank Formula in Excel What does it do?Counts the number of cells that are blankFormula breakdown:=COUNTBLANK(range)What it means:=COUNTBLANK(range of cells to check)Do you have a scenario where you want to count the number of cells that are blank in your Excel data?If y...
Change Phone Area Codes with Excel’s REPLACE Formu... What does it do?Replaces part of a text string, based on the number of characters you specify, with a different text stringFormula breakdown:=REPLACE(old_text, start_num, num_chars, new_text)What it means:=REPLACE(this cell, starting from this number, all the ...
Extract Last Name with Excel’s REPLACE Formula What does it do?Replaces part of a text string, based on the number of characters you specify, with a different text stringFormula breakdown:=REPLACE(old_text, start_num, num_chars, new_text)What it means:=REPLACE(this cell, starting from this number, all the ...