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))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
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?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!