Excel Forum
Similar Content
Count the Visible Rows in a Filtered List in Excel
Tutorial: How to use the COUNT or COUNTA function on a filtered list of data so that hidden rows ar...
WEEKNUM UDF for Excel Versions That Don't Contain This Function - UDF
Macro: This is a WEEKNUM UDF for Excel. This allows you to determine the number of the week ...
Dynamic Named Range in Excel
Tutorial: How to create a named range that expands automatically when a new value is added to the r...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



Excel Magic Trick 658: COUNT Vs. COUNTA function


See how to use the COUNT & COUNTA functions correctly. COUNT counts numbers. COUNTA counts non-empty cells. See how COUNTA counts: Logicals, Numbers, ERRORs, FORMULAs and Words. See how COUNT counts just numbers!
Don't get tricked when using the COUNTA function...





Got a Question? Ask it Here in the Forum.