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    Feb 21, 2013
user Scuzzball said:(!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:
(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.

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