Excel CountIf IsFormula?-CodePudding

Is there a way to calculate the count of items in a range, that are a formula?

I'm only expecting =TEXT formulas, so I tried =COUNTIF(1:1, "=TEXT"), but that didn't work. Seems CountIf only operates with the displayed values of the cells.

CodePudding user response：

If I have understood your post clearly, specifically you need those functions which starts TEXT() then perhaps you could try :

• Formula used in cell F6

=SUM(N(IFERROR(LEFT(FORMULATEXT(D6:D19),6)="=TEXT(",0)))

CodePudding user response：

If you have the following in cells A1:A5

=TEXT("493","DDD")
555
=TEXT("420000","YYYY")
Yep
Nope

Either of these formulas should give a result of 2

Counts formulas

=SUMPRODUCT(--ISFORMULA(A:A))

Counts Cells with Formula Text

=SUMPRODUCT(--ISNUMBER(SEARCH("text(",FORMULATEXT(A:A))))