Home » Questions » Computers [ Ask a new question ]

Date based sum in Excel / Google Docs spreadsheets

Date based sum in Excel / Google Docs spreadsheets

I have a bunch of rows with a date and a dollar amount (expenses).

Asked by: Guest | Views: 206
Total answers/comments: 1
Guest [Entry]

"The code

=SUMIF(D$2:D$30,""<=""&A5,E$2:E$30)

should work in both Excel and Google Spreadsheets."