98.1 % recommend us More live stats... RSS feeds What's this? All hints and tips:

Hints and tips home » Excel hints and tips » COUNT function vs COUNTA function

COUNT function vs COUNTA function

The COUNTA function works in the same way as the COUNT function, except that it will count cells that contain text (labels) and also cells that contain numbers (values). The COUNT function will only count cells that contain numbers. Blank cells are not counted by either the COUNT or the COUNTA function.

Added by Amanda on 2nd October 2006

More Excel hints and tips, like:

• Percentage format
• New to Excel 2010 - Sparklines!
• Counting Non Number Cells (Text)