Excel COUNTA function | Counts the cells that are not empty | Excel One Minute Quick Reference

The COUNTA function in Microsoft Excel counts the number of cells that are not empty in a range. COUNTA doesn't count just numbers. It will consider anything - text or numbers - in your range.
If you have a list of employees broken out by last name and first name, you will use COUNTA, and the range would be the last name field. If you use COUNT on last names, the result would be zero since COUNT only counts numbers or values.

In this series of one-minute Excel quick reference video tutorials, I aim to provide easy access to all of Excel's functions and formulas, in an easy to understand manner with appropriate examples so that you can get started with Excel quickly and apply the functions you need.

If you enjoy these tutorials, let me know in the comments what function I should cover next!

More Excel Quick Reference videos in my EXCEL MINUTE Playlist here:

Learn Excel with my extensive Excel collection of articles, tutorials, here:

My other Excel videos:

#excel #excelfunctions #excelcounta

NOTES:
The COUNTA function counts cells containing any type of information, including error values and empty text (""). For example, if the range contains a formula that returns an empty string, the COUNTA function counts that value. The COUNTA function does not count empty cells.

If you do not need to count logical values, text, or error values (in other words, if you want to count only cells that contain numbers), use the COUNT function.

If you want to count only cells that meet certain criteria, use the COUNTIF function or the COUNTIFS function.
//EQUIPMENT USED:

//SOFTWARE USED:

And make sure you subscribe to my channel!
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

[williamw]

I've been trying to use CountA on a sheet with a large amount of rows to get the percentage of a column that is populated vs blank. When using CountA it appears to be counting blank cells when I expect it not to, a quick search online seems that the cells I believe are blank may actually have a space populating them.

Do you know of a way to use CountA or a different function to avoid counting those cells?

Thanks!