yogi_Compute Stats By Month From A DropDown And By Year for Values In A Table

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #580    Jun 05, 2012     www.energyefficientbuild.com.

user Smileyninja said:
Trying to filter based on month
https://docs.google.com/spreadsheet/ccc?key=0AhckPttGQAT1dHVnQktJaDNGRUxrelBsMHdkZ3ZVQUE

I would like to be able to select a month in the dropdown and it would filter the schedule by the month. Ideally, I could then export to a google calendar.  I feel I'm 70% of the way to get this to work.

--------------------------------------------------

following is a solution to the problem