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).