Sumifs and Contains Function not working
I am trying to capture how many hours my employees have for vacation each month. When I use this function it is only returning a 0 value. I am not sure what else can try.
=SUMIFS({Utilization Tracker Range 1}, {Utilization Tracker Range 3}, CONTAINS("Joe Smith", @cell), {Utilization Tracker Range 2}, CONTAINS("June", @cell), {Utilization Tracker Range 4}, CONTAINS("Vacation", @cell))
Here is the reference sheet I am using
Can I not use that amount of contains in a sumifs function? Please help
Answers
-
Hi, Ryan.
Unless I'm not seeing it either, it looks like your formula is working correctly. Your screenshot of the Utilization Tracker sheet shows that Joe Smith's vacation is in August, not June.
-
I changed the contains to August and I still get a "0". I am not sure what else I can do.
-
I was able to figure this out. Thank you for everyone that was able to take a look. Here is what I changed.
=SUMIFS({Utilization Tracker Range 1}, {Utilization Tracker Range 2}, "Joe Smith", {Utilization Tracker Range 4}, "Vacation", {Utilization Tracker Range 3}, CONTAINS("June", @cell))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!