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