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


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)

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!