| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
counting with three conditions
I have columns A, B, and C
I want to count the number of rows that all three columns equal specific values. I was able to use the sumproduct function for two columns, but can't seem to get this to work for more conditions. Thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
counting with three conditions
=sumproduct(--(A1:A200=1),--(B1:B200=2),--(C1:C200=3))
-- Regards, Tom Ogilvy "Lucas Soler" wrote in message ... I have columns A, B, and C I want to count the number of rows that all three columns equal specific values. I was able to use the sumproduct function for two columns, but can't seem to get this to work for more conditions. Thanks! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
counting with three conditions
You're awsome. Thanks
"Lucas Soler" wrote: I have columns A, B, and C I want to count the number of rows that all three columns equal specific values. I was able to use the sumproduct function for two columns, but can't seem to get this to work for more conditions. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting with Conditions but Only Once | Excel Discussion (Misc queries) | |||
| Counting Blanks with Conditions | Excel Discussion (Misc queries) | |||
| Counting on two conditions, one with a range | Excel Worksheet Functions | |||
| Counting using conditions | Excel Programming | |||
| counting cell conditions | Excel Programming | |||
Hybrid Mode
