Sumifs and Contains Function not working

Ryan Ruchty

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

Toufong Vang

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.

Ryan Ruchty

I changed the contains to August and I still get a "0". I am not sure what else I can do.

Ryan Ruchty

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))