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

✭✭

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

• ✭✭✭✭✭✭

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))

• ✭✭✭✭✭✭

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))

• ✭✭

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

Thank You @Paul Newcome !!

• ✭✭✭✭✭✭

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!