Adding only numbers in a column that contain certain text in another column
I need to add only the numbers in the SUBTOTAL VACANT USEABLE AREA column where the SUITE NAME column has the text "VACANT". Some of the suite names have text in addition to "VACANT" . These numbers need to be included in the sum as well, but I've not been able to make this happen- the formula I'm using will only include the cells that only have "VACANT". I think the command "FIND" may be what I need, but I'm not familiar with how to use this command. Whatever function I use, it will be repeated for multiple floors of a building.
Thank you for your help!
Best Answer
-
Yes- It worked! Thank you so much!
Answers
-
=SUMIF([suite name]:[suite name], CONTAINS("Vacant", @cell), [subtotal vacant useable area]:[subtotal vacant useable area])
-
Yes- It worked! Thank you so much!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 396 Global Discussions
- 213 Industry Talk
- 448 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!