Struggling with using SUMIFS to sum rows within the year
Hi all- I am trying to add up the # of days in my "Actual LOS" column that are both within the year 2024 and have the "Campus 1" value under the "Referral Facility" column. I'm struggling with the the year part of the function- would appreciate any insight into how to simplify this or make this formula work. It's currently coming up as unparseable.
Thanks in advance!
=SUMIFS([Actual LOS]:[Actual LOS],[Referral Facility]:[Referral Facility],"Campus 1",[Referral Date]:[Referral Date], AND(@cell > DATE (2024, 1, 1), @cell < DATE(2024, 12, 31)))
Answers
-
Can you please try this?
=SUMIFS( [Actual LOS]:[Actual LOS], [Referral Facility]:[Referral Facility], "Campus 1", [Referral Date]:[Referral Date], >DATE(2024, 1, 1), [Referral Date]:[Referral Date], <DATE(2024, 12, 31))
If you want to incorporate the AND function…
=SUMIFS( [Actual LOS]:[Actual LOS], [Referral Facility]:[Referral Facility], "Campus 1", [Referral Date]:[Referral Date], AND(@cell >DATE(2024, 1, 1), @cell <DATE(2024, 12, 31)
...
-
the second formula worked. thank you so much!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!