Sunday, December 22, 2013

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

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

Gifts            Free Flow               $100
Groceries        Free Flow               $100
Gifts            Active Funds            $100
Groceries        Active Funds            $100
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
-----------------------------------------------------------------------------------------------------------------------------------------------------