Sumifs + Contains Formula

aneves

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

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.

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.