Search code examples
excel-formulacontainssumifs

How to check an entire Excel worksheet for specific text in formulas?

I am looking for a formula that will check an entire worksheet if any of the formulas in that worksheet contain "SUMIF". If there are any, the formula should return "Yes", otherwise "No".

Solution

  • You will need to do the following:

    1. Select a range and name it. This is so you can use it in a formula later

    2. Use the COUNTIF formula with the name range.

      =COUNTIF(YourRange, "=SUMIF")

    3. Surround that with the IF formula to transform the 1 or 0 to "Yes" or "No"

      =IF(COUNTIF(YourRange, "=SUMIF")=1, "Yes", "No")