Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif with two terms
Hi, I would like to count the number of the letter F in column A if column
B=x and column C=y (both terms must be fulfilled.) I tried countif with no success. what formula should I use? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif with two terms
=sumproduct((a2:a22="f")*(b2:b22="x")) -- Don Guillett Microsoft MVP Excel SalesAid Software "FreddieP" wrote in message ... Hi, I would like to count the number of the letter F in column A if column B=x and column C=y (both terms must be fulfilled.) I tried countif with no success. what formula should I use? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif with two terms
Try one of these:
=SUMPRODUCT(--(A2:A20="F"),--(B2:B20="X"),--(C2:C20="Y")) or... =SUMPRODUCT(--(A2:A20="F")*(B2:B20="X")*(C2:C20="Y")) Alternatively, if "X" and "Y" refer to values in other cells, perhaps something like this: =SUMPRODUCT(--(A2:A20="F"),--(B2:B20=D1),--(C2:C20=E1)) Adjust range references to suit your situation. Does that help? Post back if you have more questions. Regards, Ron Microsoft MVP - Excel "FreddieP" wrote in message ... Hi, I would like to count the number of the letter F in column A if column B=x and column C=y (both terms must be fulfilled.) I tried countif with no success. what formula should I use? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif with two terms
=SUMPRODUCT(--(A1:A100="F"),--(B1:B100="x"),--(C1:C100="y"))
-- David Biddulph "FreddieP" wrote in message ... Hi, I would like to count the number of the letter F in column A if column B=x and column C=y (both terms must be fulfilled.) I tried countif with no success. what formula should I use? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif with two different terms | Excel Discussion (Misc queries) | |||
i don;t know the correct terms but need help please! | Excel Discussion (Misc queries) | |||
Error Terms | Excel Discussion (Misc queries) | |||
how do i look up terms in excel? | Excel Discussion (Misc queries) | |||
Terms customer is using-What do they mean? | Excel Discussion (Misc queries) |