Ignoring Formulas within cells
Just:
COUNTif($A1:A20="DET")
"jimswinder" wrote:
Is there a way to have a function/formula when evalutating a cell, look at
the result of the formula within that cell and not the formula? For instance:
The formulas in range A1:A20 is =IF(LEFT($G4,3)="DET",G4,""). How can I
count/sum the instances in range A1:A20 where =IF(LEFT($G4,3)="DET",G4,"")
is true?
I have tried:
COUNTif(LEFT($A1:A20,3)="DET")
SUMIF(LEFT($A1:A20,3)="DET").
Thanks...
|