Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multi Column Sum and conditions
Hi, I have 5 sets and each set has the following - Condition 1 - Condition 2 - Amount Both the conditions can appear in any of the 5 sets. Which formula I could use to sum the Amount column based on the conditions? I tried DSUM but I could only evalute one set not all the 5 and same is the case of ConditionalSUM Wizard. -- kalim ------------------------------------------------------------------------ kalim's Profile: http://www.excelforum.com/member.php...o&userid=34700 View this thread: http://www.excelforum.com/showthread...hreadid=544667 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multi Column Sum and conditions
=SUMPRODUCT(--(rng1="Condition1"),--(rng2="Condition2"),rng3)
-- HTH Bob Phillips (remove xxx from email address if mailing direct) "kalim" wrote in message ... Hi, I have 5 sets and each set has the following - Condition 1 - Condition 2 - Amount Both the conditions can appear in any of the 5 sets. Which formula I could use to sum the Amount column based on the conditions? I tried DSUM but I could only evalute one set not all the 5 and same is the case of ConditionalSUM Wizard. -- kalim ------------------------------------------------------------------------ kalim's Profile: http://www.excelforum.com/member.php...o&userid=34700 View this thread: http://www.excelforum.com/showthread...hreadid=544667 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|