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

user Ian*R said:
Adding a column based on matching three criteria
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: 
I've also tried SUM and FILTER:
Neither gets me what I want.
Can anyone help?
following is a solution to the problem