Monday, December 3, 2012

yogi_Compute Variance Between Monthly Budgeted Amount And Actual Expenses By Category

                                          Google Spreadsheet   Post  #909
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Dec 3, 2012

user AustinS said:(!category-topic/docs/spreadsheets/KiMQ_0f5Wbo)
SUMIF Between Two Dates with Criteria 
Is this possible? 

I have a table in the following format

Date | Category | Amount
12/1/2012 | Eating Out | 10.00

I need a formula that I can pass the Category and between two dates (>=12/1/2012,<=12/31/2012) and Category = "Eating Out".

I found some formulas using the sumproduct and arrayformula features, but I cannot get them to work.
Here is my example:

following is a solution to the problem