SUMIFS only if separate cell contains certain text from a different sheet

Steve D.

Hello,

I cannot get this figured out unfortunately. I have a basic knowledge of functions with Excel but it doesn't seem to be transfering over into SmartSheet.

I am trying to SUM dollar amounts based on a few different criterion, but ONLY want the SUM IF a different cell contains a "YES". I am pulling this information from source sheet if that helps.

Here is my current formula in which I get a #UNPARSEABLE error

=SUMIFS({Unfreg trades Range 4}, {Unfreg trades Range 1}, [August 2023]$3, {Unfreg trades Range 2}, [August 2023]$2, {Unfreg trades Range 3}, $[Primary Column]@row), CONTAINS("YES", {Unreg trades Range 1}@cell)

Paul Newcome

Give this a try:

=SUMIFS({Unfreg trades Range 4}, {Unfreg trades Range 1}, [August 2023]$3, {Unfreg trades Range 2}, [August 2023]$2, {Unfreg trades Range 3}, $[Primary Column]@row, {Unreg trades Range 1}, CONTAINS("YES", @cell))

Paul Newcome

Give this a try:

=SUMIFS({Unfreg trades Range 4}, {Unfreg trades Range 1}, [August 2023]$3, {Unfreg trades Range 2}, [August 2023]$2, {Unfreg trades Range 3}, $[Primary Column]@row, {Unreg trades Range 1}, CONTAINS("YES", @cell))

Steve D.

Ahhh, I knew it was something dumb I did. LOL

Thank You @Paul Newcome !!

Paul Newcome

Happy to help. 👍️