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 |
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 |
All times are GMT +1. The time now is 04:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com