ISFORMULA

The ISFORMULA function returns TRUE if a cell contains a formula, and FALSE if not. When a cell contains a formula ISFORMULA will return TRUE regardless of the formula's output or error conditions. The ISFORMULA takes one argument, reference, which must be a cell reference. 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: 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.