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?
