Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Counting Formula
What formula do I use to count how many times a name shows up in a column?
For example:
I have a column titled "Last Name" I need to keep a running count of how many times "Smith" shows up in this column.
Comments
-
Thanks anyway. I figured it out.
-
Hi Stephanie, glad to hear you got this resolved! For the curious and future customers with this question, a solution we suggest is to add a new column to the sheet called "Count." Then, enter a COUNTIF formula in your new column that will get a count of how many times the name in the adjacent column appears.
In your example, the formula would look like the following on row 1: =COUNTIF([Last Name]:[Last Name], [Last Name]1)
Note that this formula is dynamic, and will keep a count of all of the different last names in the sheet - for a list of only Smith, plug "Smith" (including the quotes) into the formula instead of the [Last Name]1 cell reference.
Let me know if you have any questions and I'll be happy to help!
Kate
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 495 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives