Tuesday, December 6, 2011

yogi_Summarize Data By Multiple Parameters

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com


Summize with multiple parameters
user atbsav said:

For several hours I'm trying to figure out how to get this to work, but I cannot get it. It is something I would do in Excel with the function SUMIFS() but that one does not work in Google Spreadsheets.The spreadsheet:
Date       | Type    | Distance
10-01-2011 | Private |    45
10-05-2011 | Private |    18
10-20-2011 | Business|    21
11-04-2011 | Private |    18
11-11-2011 | Business|    21
11-23-2011 | Business|    42
11-26-2011 | Private |    45
12-01-2011 | Private |    18
12-05-2011 | Business|    21
12-06-2011 | Private |    18
dates are in mm-dd-yyyy
What I want to know is
Total of distance per month
Total of distance per month private
Total of distance per month business
How can I do this? With SUMIF() I can only use one parameter.
Thanks in advance for your help!
Regards,
Bas
-------------------------------------


following is solution to the problem: