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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!