Excel Forum

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.