SUMIFS with multiple criteria and date range
Hi, I am struggling in getting the following formula to work.
=SUMIFS({P-CARD Range 1}, {P-CARD Range 3}, AND(@cell>=DATE (2025, 1, 1), @cell<=(2025,12, 31)), {P-CARD Range 2}, [15]150)
Range 1 = is a column with dollar values.
Range 3 = is a column with date values.
Range 2 = is a column with specific classification codes. The specific classification code in this instance will be displayed as a static value in cell [15]150.
My issue:
I can not get the following date range syntax to work properly.
AND(@cell>=DATE (2025, 1, 1), @cell<=(2025,12, 31))
or
YEAR (2025)
I need it to pull data only within this date range or a specific year.
Any help is appreciated greatly.
Best Answer
-
That is certainly possible. Is your date column formatted as DATE? I notice it is right aligned, and date columns default to left aligned unless changed.
Answers
-
Give this a try:
=SUMIFS({P-CARD Range 1}, {P-CARD Range 3}, YEAR(@cell) = 2025, {P-CARD Range 2}, [15]150)
-
Hi Carson, thank you for the input. By logic the formula you provided should have worked. I am getting an "Invalid Data Type" error.
Would it be possible that the dates in column Range 3 are not recognized as dates by Smartsheets, but rather some other type values?
-
Here is a screenshot of where the data is pulling from (reference sheet location).
-
That is certainly possible. Is your date column formatted as DATE? I notice it is right aligned, and date columns default to left aligned unless changed.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 433 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 506 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!