Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
edit this =COUNTIF(A1:F16,"*1-2*")+COUNTIF(A1:F16,"*2-1*") | Excel Discussion (Misc queries) | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
countif max value help!!! | Excel Worksheet Functions | |||
COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions |