Excel Forum
Similar Content
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...
Count the Visible Rows in a Filtered List in Excel
Tutorial: How to use the COUNT function on a filtered list of data so that hidden rows are not incl...



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.