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
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 153 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!