Hints and tips home » Excel hints and tips » Counting Non Number Cells (Text)

Counting Non Number Cells (Text)

If you try to use the COUNT FUNCTION =COUNT(Cell range)with a range of cells with numbers and or containing text fields you wil find that that the text cells will be excluded from the the count. If you want to include them try the the COUNTA FUNCTION =COUNTA(Cell range). This counts both text and number cell values.

Added by Tom on 31st October 2006

More Excel hints and tips, like:

• Number format shortcut
• Hiding Formulae in the Formula Bar
• Creating Quick Column Charts