Count cells with text and formula – Excel stats

Count cells with text and formula – Excel stats

7 May 2016

In Excel we often like to count things. Sometimes those things are cells with text, formulas or formatting. Other times we want to count blank or non-blank cells… and so on.

This article teaches you all about counting things in Excel, using:

  • Worksheet functions to count various types of cell contents.
  • A neat VBA macro that counts every function used in all Excel formulas and presents a neat report as a result.

Note: for the VBA code to work, you'll need to save your workbook as an "Excel Macro-Enabled Workbook (*.xlsm)". The code also requires that each worksheet contains at least one formula and at least one non-formula (otherwise it will crash).