yogi_Compute Sum Of Amounts Based On Multiple Criteria In Multiple Columns

                                          Google Spreadsheet   Post  #1441
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-22, 2013
question by Slava Ross (https://productforums.google.com/forum/#!mydiscussions/docs/1rAYfMroWE8)
Multiple Criteria in Multiple Columns Formula Please Help.

Hi would love some help on the sheet that I'm doing

https://docs.google.com/spreadsheet/ccc?key=0AlJ6lDNx-7PpdG13eEgzYWJ0aS05MUU3MUJOdnh3QlE#gid=1

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

1 Gifts            Free Flow               $100

2 Groceries        Free Flow               $100

3 Gifts            Active Funds            $100

4 Groceries        Active Funds            $100

5 Gifts            Passive 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

-----------------------------------------------------------------------------------------------------------------------------------------------------