SUMIFS and Contains conditions

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?

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!