Countif
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
|