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.
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 MIwww.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").