💻 Software
Date based sum in Excel / Google Docs spreadsheets
Fresh5 days ago
Mar 15, 20262977 viewsConfidence Score0%
0%
Problem
I have a bunch of rows with a date and a dollar amount (expenses). I want to produce a list of the days of the month and what the balance of the expenses is. So, for example the 5th entry in the list would be 8/5/2008 and the sum of all the expenses that occurred on or before 8/5/2008. Approximatel…
Error Output
=sumif(D4:D30-A5,">0",E4:E30)
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Date based sum in Excel / Google Docs spreadsheets
Low Risk
The code should work in both Excel and Google Spreadsheets.
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix