COUNTIF quandry
"Bob Phillips" wrote...
=SUMPRODUCT(--(ISNUMBER(FIND("Station 1",SWABS!F7:F237))),
--(ISNUMBER(FIND("F",,SWABS!L7:L237))))
....
Note the ,, typo.
Or use just one ISNUMBER call.
=SUMPRODUCT(--ISNUMBER(FIND("Station 1",SWABS!F7:F237)
+FIND("F",SWABS!L7:L237)))
or, if the OP could suffer an array formula,
=COUNT(FIND("Station 1",SWABS!F7:F237)+FIND("F",SWABS!L7:L237))
No magic in using +. - * / would work equally well. ^ might overflow.
|