Wednesday, January 2, 2013

yogi_Summarize Expenses By Month_Year Card_Type Category And Amount


                                          Google Spreadsheet   Post  #952
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Jan 02, 2013
user justqit (question by) Arthur.lucena  said:(http://productforums.google.com/forum/?zx=cb22zc7h6wwc#!category-topic/docs/spreadsheets/KBKIOx0avPQ)
Accumulate values based on a variable

I'm needing something similar.
 
I'm making a finace spreadsheet with a focus on multiple credit cards. So in one sheet "Summary" that I have a summary of each credit card in categories (Restaurants, Games, Fuel, Taxes, etc) and by month and another sheet "Expenses" with each expenditure and some data:
 
A              B              C                   D
Date         Card         Type             Amount (US$)
12/12/12   VISA        Restaurant   12.5
13/12/12   Master     Fuel              30
 
Well, I want to sum all expenses (D2:D) with restaurant(C2:C="Restaurant") during december (something like "month(A2:A)=12") using VISA (B2:B="VISA").
 
Any help would be veery apreciate!
Thanks
---------------------------------------------------------------------------------------------------------------

following is a solution to the problem