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:


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


CountA Formula


STEP 2: The COUNTA arguments:


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


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


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


Pin on Pinterest


Share on Facebook


Tweet about this on Twitter


Share on LinkedIn


Share on Google+


Related Posts

Calculate the Compound Interest with Excel’s... What does it do? Calculates the compound interest Formula breakdown: =FV(rate, nper, pmt, ) What it means: =FV(interest rate, number of periods, periodic payment, initial amount) Say that you turn 18 years today (CONGRATS!) and you find out that your parents...
Clear Everything Before the Hyphen with Excel̵... What does it do? Replaces part of a text string, based on the number of characters you specify, with a different text string Formula breakdown: =REPLACE(old_text, start_num, num_chars, new_text) What it means: =REPLACE(this cell, starting from this number, all the ...
Add Leading Zeros in Excel Do you have a lot of numbers with an uneven number of digits in your Excel list? Do you want to make them uniform by adding leading zeros to them? Well, it's a pain to add zeros in front of them one by one! Thankfully, Excel allows you to add leading zeros with one singl...
Extracting Data with Excel’s LEFT Formula What does it do? It returns the first character or characters in a text string, based on the number of characters you specify. Formula breakdown: =LEFT(text, ) What it means: =LEFT(look in this cell, extract X characters) There are times when you will need t...