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

Find more posts tagged with

Accepted answers

All comments

TVang

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.