Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match function multiple items | Excel Worksheet Functions | |||
COUNTIF or SUM function (Multiple criteria) HELP!! | Excel Worksheet Functions | |||
Sum function across multiple sheets | Excel Worksheet Functions | |||
countif function with multiple criteria | Excel Discussion (Misc queries) | |||
Multiple Worksheets and Print Merge function | Excel Discussion (Misc queries) |