# Trying to find a formula to sum a column that has

Options

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.

• ✭✭✭✭✭✭
Options

Here you go...

=SUMIFS([Total Pieces of Media]:[Total Pieces of Media], Description:Description, CONTAINS("new", @cell))

• ✭✭✭✭
Options

Hello!

Try something like this:

=SUMIF({Description}, CONTAINS("New", @cell), {Value})

Hope this helps!

• Options

• Options

here are three formulas that I have tried but they either return #UNPARSEABLE or #BLOCKED:

=SUMIFS([Total Pieces of Media]:[Total Pieces of Media], Description:Description, "new")

=SUM([Total Pieces of Media]:[Total Pieces of Media], IF(CONTAINS("new", Description:Description)))

=SUM([Total Pieces of Media]:[Total Pieces of Media],@row),IF(CONTAINS("new", Description:Description))))

• ✭✭✭✭✭✭
Options

The first one should be working. Which error is that one generating?

• Options

That is exactly what I thought, but it is giving the #BLOCKED error.

• Options

So I figured out why it is blocked and was able to get the formula to work, but I need it to be a 'contains "new" because each description cell has sentences and I am just trying to pick out the specific word to give the sum.

I hope that makes sense.

• ✭✭✭✭✭✭
Options

Here you go...

=SUMIFS([Total Pieces of Media]:[Total Pieces of Media], Description:Description, CONTAINS("new", @cell))

• Options

THANK YOU! THANK YOU! THANK YOU! It is always the capitals and the commas that get me! You made my day! I hope you have a great day!

• ✭✭✭✭✭✭
Options

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!