Thursday, February 21, 2013

yogi_Compute Sum Of Hours For Specified Date Ranges


                                          Google Spreadsheet   Post  #1040
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Feb 21, 2013
user Scuzzball said:(http://productforums.google.com/forum/?zx=3s6yw9idkqjm#!category-topic/docs/spreadsheets/W8sXsn9why0)
Summing numbers between dates
So I have read a few questions similar to this, but I wasn't able to understood how the answer worked, or was to make the answers work for me.

Sample data: 
https://docs.google.com/spreadsheet/ccc?key=0AqU4LU4RNy0AdGRHWUdfcFcydkN0blV1NURXaXlKYlE#gid=0
(World writable)

I know SQL well enough, so I was trying to use the query function, but I did it wrong, and am not really sure what.

I don't just want the answer, I actually want to understand the function.

Many, many thanks for any help.
Mark.

---------------------------------------------------------------------------------------------------------------
in the following solution I have also included one array solution for the entire set of date ranges