Looking to count the number of times a string of specific text occurs in a column
I want to use a count formula to determine the number of times a SKU occurs in an open text column.
Below is the formula for the highlighted cell:
=COUNTIF(SKU:SKU, CONTAINS("SKU2", @cell))
The value I am looking for is 3 because SKU2 appears 2 times in the 3rd row and once in the 2nd row.
Any insights on how to count this?
Many thanks,
Answers
-
Hi @riouxs
I think the issue here is that you have several data points in your third row. The formula is counting whether it is present or not - not how many times per cell.
The formula would work better if you made sure each cell/ row contained one data set.
The above would work if you had one data set per cell and used : =COUNTIF(SKU1:SKU9, "SKU2")
Although there might be a more clever way of doing it - I have attempted using multiple select dropdown columns but it still only counts one per cell.
Alex
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!