SUMIFS and Contains conditions

Amy Martin

Hi all- I have a formula that refers to another sheet to sum costs based on some criteria:

=SUMIFS({Professional Services Project Costs Amount}, {Professional Services Project Costs Grant Code}, $[Budget Allocated]$8, {Professional Services Project Costs Category}, CONTAINS([Budget Category]28, @cell))

I'd like to add another condition, which is to find the name "Denise" in a text column where we put notes, so I tried the following, but got INCORRECT ARGUMENT:

=SUMIFS({Professional Services Project Costs Amount}, {Professional Services Project Costs Grant Code}, $[Budget Allocated]$8, {Professional Services Project Costs Category}, CONTAINS([Budget Category]28, @cell), {Goods & Services Project Costs Notes}, CONTAINS("Denise"))

Any Tips?

Paul Newcome

It should be working. Hmm...

Log out

Clear your cookies and cache

Log back in

See if that clears things up for you.

Paul Newcome

You just need an @cell reference is all...

=SUMIFS({Professional Services Project Costs Amount}, {Professional Services Project Costs Grant Code}, $[Budget Allocated]$8, {Professional Services Project Costs Category}, CONTAINS([Budget Category]28, @cell), {Goods & Services Project Costs Notes}, CONTAINS("Denise", @cell))

Amy Martin

Paul, Unfortunately I am still getting an Incorrect Argument message with the @cell....

(new to this community, do I need to @ you when I respond? @Paul Newcome )

Paul Newcome

That's odd. The syntax is otherwise correct. Can you provide a screenshot of the formula in the sheet similar to the screenshot here?

Amy Martin

Maybe this makes a difference- i see the error code is "Incorrect Argument Set"

Paul Newcome

The @cell should be inside of the CONTAINS function like I have it in the formula above.

CONTAINS("Denise", @cell))

Amy Martin

Oof, still no-

Paul Newcome

Are you still getting the same error?

Amy Martin

Yes, INCORRECT ARGUMENT SET

It doesn't like the addition of the last condition...

Paul Newcome

It should be working. Hmm...

Log out

Clear your cookies and cache

Log back in

See if that clears things up for you.

Amy Martin

Wow, yes, went into another browser, changed the formula, and it worked.

Thanks for your time!

Paul Newcome

Happy to help. 👍️