software

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 quot;less than 3 feetquot; repair for each diameter pipe separately
and total length of quot;between 3 to 8 feetquot; repair separately. I tried
using the quot;sumifquot; 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,quot;=8,ifg*=3quot;,G2:G88)

Thanks!
S.
Hi, how about something like this:

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

or

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

HTH
JG--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: www.excelforum.com/member.php...foamp;userid=6261
View this thread: www.excelforum.com/showthread...hreadid=494131try

=SUMPRODUCT((H1:H21gt;3)*(H1:H21lt;8)*H1:H21)
--
Don Guillett
SalesAid Software

quot;sangeequot; gt; wrote in message oups.com...
gt; Hello!
gt; I am trying to generate a summary table. My primary table has a number
gt; of pipes different pipe diameters (8, 12, 15, 21, 24), on which
gt; different lengths of pipe repair need to be performed (less than 3 feet
gt; and between 3 to 8 feet). I want the summary table to display total
gt; length of quot;less than 3 feetquot; repair for each diameter pipe separately
gt; and total length of quot;between 3 to 8 feetquot; repair separately. I tried
gt; using the quot;sumifquot; condition using a nested if for the criteria. But, it
gt; doesnt seem to help. Would appreciate any help/ advice.
gt;
gt; This is the formula that I tried to use...
gt;
gt; =SUMIF(H2:H88,quot;=8,ifg*=3quot;,G2:G88)
gt;
gt; Thanks!
gt; S.
gt;