Forum home » Delegate support and help forum » Microsoft Excel Training and help » Count Functions
James has attended:
Excel Advanced course
What is the difference between COUNT and COUNTA?
Hi James
The COUNT function counts the cells in a range containing numbers. It ignores cells with non-numeric or blank cells
COUNTA counts all cells containing values whether text or numeric. It only ignores blank cells
Hope this helps
Carlos
Wed 28 Jan 2009: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question.
Our Microsoft Qualified trainers will then respond within 24 hours (working days).
Frequently Asked Questions
What does 'Resolved' mean?
Any suggestions, questions or comments? Please post in the Improve the forum thread.
If you want to hide columns not adjacent to each other for example, Columns A, C and E then:-
1) Click on the fist column to be hidden i.e. A
2) Press and hold down the CTRL key
3) While holding the CTRL key, left click on the rest of the columns you want to hide i.e. C and E
4) Right click and choose Hide
TrustScore
4.9
/ 5
2472 reviews
Call for assistance
We will call you back
Formerly Best Training
© 2026 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
Software Training London Ltd. t/a STL
2nd Floor, CA House, 1 Northey Street,
Limehouse Basin, London, E14 8BT, United Kingdom.
Registered in England and Wales.
