Date Formula
I am trying the add numbers within certain date ranges that are from today’s date, and between 30 to 180 days in the past. For example, see below table
DATE NUMBER
10 Feb, 2019 2
14 Jun, 2019 6
15 Oct, 2019 5
28 Nov, 2019 3
I want to add just the 5 and 6, and get 11 as my answer in my Summary Sheet Formulae cell.
What is the formula for doing this ?
Comments
-
Hi,
Try something like this.
=SUMIFS(NUMBER:NUMBER; DATE:DATE; <TODAY(-30); DATE:DATE; >TODAY(-180))
The same version but with the below changes for your and others convenience.
=SUMIFS(NUMBER:NUMBER, DATE:DATE, <TODAY(-30), DATE:DATE, >TODAY(-180))
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
Did it work?
I hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!