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:
https://www.youtube.com/playlist?list=PLsYjn_fAfG41-NEswWjtTnAW1OjliJf6u

Learn Excel with my extensive Excel collection of articles, tutorials, here:
https://chrismenardtraining.com/excel

My other Excel videos:
https://www.youtube.com/playlist?list=PLsYjn_fAfG42S1JmTFr7B5eTQRvm5w3sF

#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:
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6

//SOFTWARE USED:
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screen shots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard

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 ---------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6

-- SOFTWARE USED ---------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard

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 ---------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6

-- SOFTWARE USED ---------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard

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!