help needed on "sumif function with multiple ifs"

S

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

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
J
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a summary Page 4
Page numbering with Merged Document and IF statements 1
Indirect and sumif functions with multiple workbooks 1
summary 1
Using SumIf Across Multiple Worksheets - Excel 2003 0
What Multiple functions do I need? 2
Totally confused by SUMIF 3
sumif function with multiple sheets 8

Top