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
-
Here you go...
=SUMIFS([Total Pieces of Media]:[Total Pieces of Media], Description:Description, CONTAINS("new", @cell))
Answers
-
Hello!
Try something like this:
=SUMIF({Description}, CONTAINS("New", @cell), {Value})
Hope this helps!
-
Thank you so much for answering! Sadly this did not work.
-
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))))
-
The first one should be working. Which error is that one generating?
-
That is exactly what I thought, but it is giving the #BLOCKED error.
-
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.
-
Here you go...
=SUMIFS([Total Pieces of Media]:[Total Pieces of Media], Description:Description, CONTAINS("new", @cell))
-
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!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!