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