| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count if - 2 conditions
Hi:
How would I write A "COUNT IF AND" formula? I tried COUNT IF AND(E5:E30,"MAMA"),(B:5:C30,"4"), but there is an error somewhere. Thanks in advance. Escarly |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count if - 2 conditions
COUNT IF AND(E5:E30,"MAMA"),(B:5:C30,"4"),
It depends on how you want this to count. You're referencing a 2 column range with B5:C30. What result do you expect with this sample: ......B.....C.....E ......4.....4....Mama ......1.....4....Mama Should the result be 2 or 3? -- Biff Microsoft Excel MVP "orquidea" wrote in message ... Hi: How would I write A "COUNT IF AND" formula? I tried COUNT IF AND(E5:E30,"MAMA"),(B:5:C30,"4"), but there is an error somewhere. Thanks in advance. Escarly |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count if - 2 conditions
=SUMPRODUCT((E5:E30="mama")*(C5:C30=4))
Vaya con Dios, Chuck, CABGx3 "orquidea" wrote: Hi: How would I write A "COUNT IF AND" formula? I tried COUNT IF AND(E5:E30,"MAMA"),(B:5:C30,"4"), but there is an error somewhere. Thanks in advance. Escarly |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count if - 2 conditions
Good catch Biff...........I was reading out of my dominant eye again........<g
Vaya con Dios, Chuck, CABGx3 "T. Valko" wrote: COUNT IF AND(E5:E30,"MAMA"),(B:5:C30,"4"), It depends on how you want this to count. You're referencing a 2 column range with B5:C30. What result do you expect with this sample: ......B.....C.....E ......4.....4....Mama ......1.....4....Mama Should the result be 2 or 3? -- Biff Microsoft Excel MVP "orquidea" wrote in message ... Hi: How would I write A "COUNT IF AND" formula? I tried COUNT IF AND(E5:E30,"MAMA"),(B:5:C30,"4"), but there is an error somewhere. Thanks in advance. Escarly |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count if - 2 conditions
I excpect 2, because rows have the 2 conditions "mama" and "4"
"T. Valko" wrote: COUNT IF AND(E5:E30,"MAMA"),(B:5:C30,"4"), It depends on how you want this to count. You're referencing a 2 column range with B5:C30. What result do you expect with this sample: ......B.....C.....E ......4.....4....Mama ......1.....4....Mama Should the result be 2 or 3? -- Biff Microsoft Excel MVP "orquidea" wrote in message ... Hi: How would I write A "COUNT IF AND" formula? I tried COUNT IF AND(E5:E30,"MAMA"),(B:5:C30,"4"), but there is an error somewhere. Thanks in advance. Escarly |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count if - 2 conditions
Try this:
=SUMPRODUCT(--((B5:B30=4)+(C5:C30=4)0),--(E5:E30="mama")) -- Biff Microsoft Excel MVP "orquidea" wrote in message ... I excpect 2, because rows have the 2 conditions "mama" and "4" "T. Valko" wrote: COUNT IF AND(E5:E30,"MAMA"),(B:5:C30,"4"), It depends on how you want this to count. You're referencing a 2 column range with B5:C30. What result do you expect with this sample: ......B.....C.....E ......4.....4....Mama ......1.....4....Mama Should the result be 2 or 3? -- Biff Microsoft Excel MVP "orquidea" wrote in message ... Hi: How would I write A "COUNT IF AND" formula? I tried COUNT IF AND(E5:E30,"MAMA"),(B:5:C30,"4"), but there is an error somewhere. Thanks in advance. Escarly |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count if - 2 conditions
thanks
"T. Valko" wrote: Try this: =SUMPRODUCT(--((B5:B30=4)+(C5:C30=4)0),--(E5:E30="mama")) -- Biff Microsoft Excel MVP "orquidea" wrote in message ... I excpect 2, because rows have the 2 conditions "mama" and "4" "T. Valko" wrote: COUNT IF AND(E5:E30,"MAMA"),(B:5:C30,"4"), It depends on how you want this to count. You're referencing a 2 column range with B5:C30. What result do you expect with this sample: ......B.....C.....E ......4.....4....Mama ......1.....4....Mama Should the result be 2 or 3? -- Biff Microsoft Excel MVP "orquidea" wrote in message ... Hi: How would I write A "COUNT IF AND" formula? I tried COUNT IF AND(E5:E30,"MAMA"),(B:5:C30,"4"), but there is an error somewhere. Thanks in advance. Escarly |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count if - 2 conditions
You're welcome!
-- Biff Microsoft Excel MVP "orquidea" wrote in message ... thanks "T. Valko" wrote: Try this: =SUMPRODUCT(--((B5:B30=4)+(C5:C30=4)0),--(E5:E30="mama")) -- Biff Microsoft Excel MVP "orquidea" wrote in message ... I excpect 2, because rows have the 2 conditions "mama" and "4" "T. Valko" wrote: COUNT IF AND(E5:E30,"MAMA"),(B:5:C30,"4"), It depends on how you want this to count. You're referencing a 2 column range with B5:C30. What result do you expect with this sample: ......B.....C.....E ......4.....4....Mama ......1.....4....Mama Should the result be 2 or 3? -- Biff Microsoft Excel MVP "orquidea" wrote in message ... Hi: How would I write A "COUNT IF AND" formula? I tried COUNT IF AND(E5:E30,"MAMA"),(B:5:C30,"4"), but there is an error somewhere. Thanks in advance. Escarly |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count on multiple conditions | Excel Worksheet Functions | |||
| Count with 2 conditions, second one OR | Excel Worksheet Functions | |||
| How to count after 2 conditions are met | Excel Worksheet Functions | |||
| Count ifs - 2 conditions | Excel Discussion (Misc queries) | |||
| Count with 2 conditions? | Excel Worksheet Functions | |||
Linear Mode
