| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif and or
Thank you Bob. This worked perfectly.
"Bob Phillips" wrote: Sorry about that =SUMPRODUCT(--(Input!A2:A20="PPAO"),--(((Input!B2:B20=1)+(Input!C2:C20=1)+(Input!D2:D20= 1)<0))) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "jimar" wrote in message ... Thanks Bob but this is adding together the number 1s when they appear along with PPAO. What I need to count is the number of rows that contain PPAO when there is a number 1 in either col B or C or D. So if row 6 has PPAO in Col A and the number 1 in Col B and number 1 is also in C the answer to the formula should be 1 (not 2). "Bob Phillips" wrote: =SUMPRODUCT(--(Input!A2:A200="PPAO"),--((Input!B2:B200=1)+(Input!C2:C200=1)+(Input!D2:D20 0=1))) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "jimar" wrote in message ... I have an input sheet which contains the data and a summary sheet. I need to put a formula in the summary sheet to count the number of rows in which the following may occur "PPAO" is in Column A and the number 1 is in either columns B or C or D. Any help appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" | Excel Worksheet Functions | |||
| sumif #value | Excel Worksheet Functions | |||
| Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
| nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
| SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
Threaded Mode
