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/
(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.
---------------------------------------------------------------------------------------------------------------
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/
(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
No comments:
Post a Comment