How to sum values between two dates range in Excel?
When there are two lists in your worksheet as right screenshot shown, one is the list of dates, the other is the list of the values. And you want to sum up the values between two dates range only, for instance, sum up the values between 3/4/2014 and 5/10/2014, how can you calculate them quickly? Now, I introduce a formula for you to sum up them in Excel.
Recommended Productivity Tools
Fortunately, there is a formula can sum up the values between two dates range in Excel.
Select a blank cell and type into this formula =SUMIFS(B2:B8,A2:A8,">="&E2,A2:A8,"<="&E3), and press Enter button. And now you will get the calculating result. See screenshot:
Note: In above formula, B2:B8 is the value list you will sum up, A2:A8 is the date list you will sum based on, E2 is the cell with start date, E3 is the cell with end date, and you can change them based on your needs.
|Formula is too complicated to remember? Save the formula as an Auto Text entry for reusing with only one click in future!
Read more… Free trial
Recommended Productivity Tools
Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.
Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!
200 New Features for Excel, Make Excel Much Easy and Powerful:
- Merge Cell/Rows/Columns without Losing Data.
- Combine and Consolidate Multiple Sheets and Workbooks.
- Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion.
- Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,
- More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools...
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
To post as a guest, your comment is unpublished.· 1 months agoVery helpful, thanks!
To post as a guest, your comment is unpublished.· 3 months agoIf I wanted to incorporate another IF into this formula how would I do it? My formula looks like this:
I also want to include a variable in CELL D52 from the range of D2:D51.
To post as a guest, your comment is unpublished.· 1 months agoCan you do like this
To post as a guest, your comment is unpublished.· 3 months agoHi Darren,
If you are not familiar with the SUMIFS function, you can click Formulas > Insert Functions, type SUMIFS in the search for a function box, and click the Go button, and then specify as much criteria as you need in the Function Arguments dialog box. See screenshot:
To post as a guest, your comment is unpublished.· 3 months ago=SUMIFS(Expenses!D6:K300,Expenses!C6:C300,"> ="&References!B5,Expenses!C6:C300,"< ="&References!C5)
returns #VALUE. Where am I going wrong? Expense tab, column C has dates. Expenses tab columns D thru K have the $$ amounts that need to be summed. References tab B5 has beginning date. References tab C5 has ending date.
To post as a guest, your comment is unpublished.· 4 months agoDATED wgt
i want to calculate date wise weight and convert to month
To post as a guest, your comment is unpublished.· 4 months agoHi Hardik,
Do you mean summing by month? Methods introduced in this article may help you:
To post as a guest, your comment is unpublished.· 6 months agothanks bro it's working