Sunday, June 10, 2012

yogi_Sum Up A Column In A Table Based On Multiple Criteria

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #586    Jun 10, 2012     www.energyefficientbuild.com.

user Ian*R said:
Adding a column based on matching three criteria
Hi--
I want to sum column E if the following criteria are matched:
The date in Column B is on or after 1/1/2012
The date in Column B is also on or before 1/31/2012
The Category in Column A equals "Donations"
I've tried using SUMIF: 
=SUMIF(Items!B2:B897&Items!B2:B897&Items!A2:A897;">=1/1/12"&"<=1/31/12"&"Donations";Items!E2:E897)
I've also tried SUM and FILTER:
=SUM(FILTER(Items!E:E,Items!B:B>="1/1/12"&Items!B:B<="1/31/12",Items!A:A="donations"))
Neither gets me what I want.
Can anyone help?
Thanks,
Ian
----------------------------------------------------------
following is a solution to the problem