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    Jan 02, 2013
user justqit (question by) Arthur.lucena  said:(!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!

following is a solution to the problem