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 |