If cell A1 contains the formula =2+2, the ISFORMULA function returns TRUE: If cell A1 contains the text “apple”, the ISFORMULA function returns FALSE:

Count formulas

To count cells in a range that contain formulas, you can use the SUMPRODUCT function like this: The double negative coerces the TRUE and FALSE results from ISFORMULA into 1s and 0s and SUMPRODUCT returns the sum.


You can temporarily display all formulas in a worksheet with a keyboard shortcut. To extract and display a formula as text, use the FORMULATEXT function.

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.