google sheets
I have a Google Spreadsheet in the format below — here's an example.
I'd like to sum values in column B in a range of dates in column A.
Example:
Sum values between 01-feb-12 and 29-feb-12.
In Excel, I used the following formula:
=SUMPRODUCT(N(A1:A1000>=A35),N(A1:A1000<=A36),B1:B1000)
where:
The following formula would yield the most elegant presentation.
=QUERY(DATA!A:C, "SELECT A, SUM(C) WHERE A IS NOT NULL GROUP BY A PIVOT B")
This is a good alternative, but formula wise a bit different.
=QUERY(DATA!A:C, "SELECT A, B, SUM(C) WHERE A IS NOT NULL GROUP BY A, B
LABEL SUM(C) 'Costs'")
I've added the results into your dummy sheet.
UPDATE: Today Google added filtering conditions to Google Sheets.
At this time the filter feature of Google Sheet doesn't include date range filtering.
References
Filter you data - Docs editors help
Google Sheets: Do more with your data - Google Docs Blog
Best Answer
This works, see F35 in your sheet:
SUMIF(E2:E33;">="&E35;B2:B33)-SUMIF(E2:E33;"<="&E36;B2:B33)column E is done by calculating a value for the dates to be able to compare them (
=VALUE(E1))Note that separating the args for some reasons is done with
;