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 agohai Friends I have one dout, how to calculate how many dates between one date to another date.
To post as a guest, your comment is unpublished.· 1 months agodoes the date format matter?
The formula when i type the 5th July as 5/7/2018, the formula is picking up 7th May instead.
To post as a guest, your comment is unpublished.· 5 months agoHi there,
I want to use a IF formula to pick up the number in a cell, only if the dates in which it rates to fall between two dates. Eg if the start date is between the two dates, then pick up a number from the cell.
To post as a guest, your comment is unpublished.· 7 months agoVery helpful, thanks!
To post as a guest, your comment is unpublished.· 9 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.· 7 months agoCan you do like this
To post as a guest, your comment is unpublished.· 9 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: