Hi Steve,

Thanks for replying but couldn't make this one work.

Cheers
--
Mifty


"stevefromnaki" wrote:

Hi,

You can combine countif functions. In your case you can have a formula
similar to:
=countif(B2:B10,"=456") + countif(B2:B10, "S") + countif(B2:B10, "Yes")

Hope this helps,

stevefromnaki :)

"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