With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
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 MIwww.energyefficientbuild.com. Dec 3, 2012 user AustinS said:(http://productforums.google.com/forum/#!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.