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