Help with SUMIF Formula
Options
Chloe MB
✭✭✭
Hey Community,
I need some assistance with a SUMIF formula. I am trying to say, Multiply Column 1 by Column 2 IF Column 1 is greater than 1, if not, leave blank.
I have tried several different ways but all keep coming back #UNPARSEABLE. Would appreciate some help with this.
Thank you in advance!
Best Answer
-
Hi @Chloe MB,
Try this formula in Column3:
=IF([Column1]@row > 1, [Column1]@row * [Column2]@row, "")
Hope it works.
Gia Thinh Technology Co., LTD - Smartsheet Solution Partner.
Answers
-
Hi @Chloe MB,
Try this formula in Column3:
=IF([Column1]@row > 1, [Column1]@row * [Column2]@row, "")
Hope it works.
Gia Thinh Technology Co., LTD - Smartsheet Solution Partner.
-
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!