Trying to find a formula to sum a column that has

Olivia Doiron

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

Paul Newcome

Here you go...

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

Javed Hassan

Hello!

Try something like this:

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

Hope this helps!

Olivia Doiron

Thank you so much for answering! Sadly this did not work.

Olivia Doiron

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

Paul Newcome

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

Olivia Doiron

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

Olivia Doiron

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.

Paul Newcome

Here you go...

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

Olivia Doiron

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!

Paul Newcome

Happy to help. 👍️