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:

• Make a quick copy of a worksheet
• Converting an American date format to European using Formula
• Select only cell that contain text to lock format