Trying to find a formula to sum a column that has


I am trying to find the best formula to accomplish the following:

I have a Description column and a Totals column; I am trying to write a formula that will find the word "new" in the description column and then sum the totals column from that same row with the word new. I am truly at a loss as to where to start. Tried an =IF(CONTAINS) with a nesting =SUM, but am not sure if this would be the best way to tackle this.

Thank you for any help you can give! :)

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!