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: