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.
|