How to sum numbers of last 7 or 30 days including TODAY in Excel?
Author: SunLast Modified: 2020-07-24
Here are two column data, one is the date list, the other list contains worked hour records, and now I want to sum the last 7 numbers in Worked Hours column including today automatically as below screenshot shown, how can I quickly solve it in Excel?
Select a blank cell which you will place the summing result into, type this formula =SUMIFS(B:B,A:A,">"&TODAY()-7)-SUMIFS(B:B,A:A,">"&TODAY()) and press Enter key. See screenshot:
Now the numbers in last 7 days including today have been added.
Tip: in the formula, A:A is the column containing dates, B:B is the column containing the values you want to add up, 7 means last 7 days, you can change them as you need.
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
This comment was minimized by the moderator on the site
Great help, but having some issues, I'm using a spreadsheet with multiple tabs and it doesn't sum it, it simply comes out to #VALUE! My main tab is called dashboard (for the summary) and my second tab is called Detail (for the detailed work within the summary).
Formula - =SUMIFS(Detail!R4:R194,A2:A194,">"&TODAY()-30)-SUMIFS(Detail!R4:R194,A2:A194,">"&TODAY())