I have a Google Docs spreadsheet in the format below — here's an example.
- Column A → Dates
- Column B → Numbers
I'd like to sum values in column B in a range of dates in column A.
Sum values between 01-feb-12, and 29-feb-12.
In Excel, I used the following formula:
- A35 = Start Date
- A36 = Last date