Sumifs + Contains Formula

Hello!

I’m trying to sum the total hours from another sheet based on a specific name and a time activity code. Since there are multiple activity codes I need to consider, I’m using "contains" in my formula, but I’m having trouble getting it to work correctly.

Here’s the formula I’ve been trying:

=SUMIFS({Timesheet Summary- Mar 2025 N/B}, {Timesheet Summary- Mar 2025 Name}, Name@row), CONTAINS("FLA", {Timesheet Summary- Mar 2025 AC})

Would you be able to take a look and help me figure out what’s going wrong? I appreciate any guidance you can provide!

Thanks

Find more posts tagged with

Accepted answers

Paul Newcome

Your syntax is a bit off. Try this format instead:

=SUMIFS({Range To Sum}, {Name}, Name@row, {Leave Type}, CONTAINS("FLA", @cell))

Paul Newcome

The "@cell" needs to be in the CONTAINS function how I have it in my previous example.

All comments

Paul Newcome

Your syntax is a bit off. Try this format instead:

=SUMIFS({Range To Sum}, {Name}, Name@row, {Leave Type}, CONTAINS("FLA", @cell))

aneves

Hi Paul! Thanks. I think something is still missing because it's comes back to no value.

=SUMIFS({Range To Sum}, {Name}, Name@row, {Leave Type}, CONTAINS("PTO", {Leave Type})

Paul Newcome

The "@cell" needs to be in the CONTAINS function how I have it in my previous example.

aneves

It worked! thank you!!

Paul Newcome

Happy to help. 👍️

hdierkers

I am trying something similar but with just one condition. I am trying to calculate the number of assigned hours with an in-progress status - there are 2 options in the source sheet. I can't get it to cooperate and get an error every time

=SUMIF({Copy of Short-Term Resourcing Mock Allocated Hours}, {Copy of Short-Term Resourcing Mock Status}, CONTAINS("In-Progress", @cell))

Paul Newcome

@hdierkers Try switching to a SUMIFS function. The syntax for SUMIF vs SUMIFS is different, and you are using the SUMIFS syntax.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.