Sumifs with references and dates not calculating
HELP!!!! I am working in a summary metrics sheet. I am trying to find the total projected revenue by month. I have created 2 references, the revenue column to sum, and the date column. For some reason I keep getting 0 even though there is revenue in the column for that date. I can't figure out what is wrong with my formula.
=SUMIFS({Implementation List with Form Range 7}, {Front Office Team Range 1}, <=DATE(2023, 1, 1), {Front Office Team Range 1}, >=DATE(2023, 1, 31))
This is trying to find the projected revenue for January
Best Answer
-
As written, you will not get any matches. Your formula is looking for a date that is both less than or equal to January First and Greater than or equal to January 31st. You will need to reverse those to match January numbers.
Answers
-
As written, you will not get any matches. Your formula is looking for a date that is both less than or equal to January First and Greater than or equal to January 31st. You will need to reverse those to match January numbers.
-
Oh my goodness! Thank you so much for catching that!!
-
Far too often, its the little things...
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!