help needed on "sumif function with multiple ifs"

[sangee]

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.

[pinmaster]

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

[Don Guillett]

try

=SUMPRODUCT((H1:H21>3)*(H1:H21<8)*H1:H21)
--
Don Guillett
SalesAid Software
[email protected]
"sangee" <[email protected]> wrote in message
news:[email protected]...
> 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.
>