=SUMPRODUCT(--(A1:A100=456),--(B1:B100="S"),--(C1:C100="Yes"))
For more details on SUMPRODUCT
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
http://mcgimpsey.com/excel/formulae/doubleneg.html
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
"Mifty" wrote in message
...
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