Countif
Hi Mike,
That does the trick
Thank you
--
Mifty
"Mike H" wrote:
Maybe
=SUMPRODUCT((A1:A20=456)*(B1:B20="S")*(C1:C20="Yes "))
Mike
"Mifty" wrote:
Hi everyone,
I'm hoping someone can help me with another one please.
I want to do a countif with 3 criteria. If A is 456 and B is S and C is Yes.
Just can't seem to think straight today
Thanking you in advance
Cheers
--
Mifty
|