## Sunday, December 22, 2013

### yogi_Compute Sum Of Amounts Based On Multiple Criteria In Multiple Columns

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-22, 2013
Hi would love some help on the sheet that I'm doing

basically I want Column H Added in a random cell that meets D(Groceries, Gifts) and Column G(Free Flow). But if Column D and G have criteria met at the same time it still only adds once.

Any help appreciated been on int for over 4h. Can't figure it out.
---
 What mreighties was saying is correct. 4:45 PM (6 hours ago)

If I understand correctly, Slava wants to just add the total "Gifts/Free Flow", but not to include the total "Groceries/Free Flow".

D                     G                      H

Groceries        Free Flow               \$100
Groceries        Active Funds            \$100
6 Gas              Active Funds            \$100
7 Gas              Free Flow               \$100

The formula would add amounts in H together. So in my example it would total to \$600.
It will not calculate row 1,2 twice because it has Gifts and Free flow or Groceries and Free flow in one row.
thank you guys for your time and helping me
-----------------------------------------------------------------------------------------------------------------------------------------------------