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.