help needed on "sumif function with multiple ifs"
 

Hello!
I am trying to generate a summary table. My primary table has a number
of pipes different pipe diameters (8, 12, 15, 21, 24), on which
different lengths of pipe repair need to be performed (less than 3 feet
and between 3 to 8 feet). I want the summary table to display total
length of "less than 3 feet" repair for each diameter pipe separately
and total length of "between 3 to 8 feet" repair separately. I tried
using the "sumif" condition using a nested if for the criteria. But, it
doesnt seem to help. Would appreciate any help/ advice.

This is the formula that I tried to use...

=SUMIF(H2:H88,"=8,ifg*=3",G2:G88)

Thanks!
S.

help needed on "sumif function with multiple ifs"
 

Hi, how about something like this:

=SUMPRODUCT((H2:H88=8)*(G2:G88<3),(G2:G88))

or

=SUMPRODUCT((first criteria)*(second criteria),(range to sum))

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=494131

help needed on "sumif function with multiple ifs"
 

try

=SUMPRODUCT((H1:H213)*(H1:H21<8)*H1:H21)
--
Don Guillett
SalesAid Software

"sangee" wrote in message
oups.com...
Hello!
I am trying to generate a summary table. My primary table has a number
of pipes different pipe diameters (8, 12, 15, 21, 24), on which
different lengths of pipe repair need to be performed (less than 3 feet
and between 3 to 8 feet). I want the summary table to display total
length of "less than 3 feet" repair for each diameter pipe separately
and total length of "between 3 to 8 feet" repair separately. I tried
using the "sumif" condition using a nested if for the criteria. But, it
doesnt seem to help. Would appreciate any help/ advice.

This is the formula that I tried to use...

=SUMIF(H2:H88,"=8,ifg*=3",G2:G88)

Thanks!
S.