Thread: Multi Column Sum and conditions
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kalim
 
Posts: n/a
Default 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

Reply With QuoteReply With Quote