Countif
 

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

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

Countif
 

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

Countif
 

=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

Countif
 

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

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

Countif
 

Thank you Bernard,

I'll definitely follow the links because I've seen lots of posts where
sumproduct is given as an alternative option and I've always chickened out of
using the "more complicated option". But now I've seen it in use..........

Thanks again
--
Mifty


"Bernard Liengme" wrote:

=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