Count Number of Occurrences of Each Value in a Column
Is there a way to count the number of occurrences in a column like the Excel example in the link below without separately naming each occurrence in the formula?
https://www.exceldemy.com/excel-count-number-of-occurrences-of-each-value-in-a-column/
Currently, I have two columns of information pulling from a live sheet (Sheet 1) into another sheet (sheet 2). Sheet 2 is then connected to a dashboard in Power Bi.
Answers
-
Have you tried using summary fields? This works well when you have a limited number of unique values. For example, if you want to count the number of times "Dog" was selected in a column "Type of Animal", you can create a summary field and put below formula in it
=COUNTIF([Type of Animal]:[Type of Animal], "Dog")
For a similar situation where the number of unique values are not limited, using report, grouping it by the Type of Animal and showing count in summary would be a choice.
I hope this helps.
Regards
Amit Wadhwani, Smartsheet CoE, Ignatiuz Software, Exton, PA
Best Regards
Amit Wadhwani, Smartsheet Community Champion
Smartsheet CoE, Ignatiuz, Inc., Exton, PA
Did this answer help you? Show some love by marking this answer as "Insightful 💡" or "Awesome ❤️" and "Vote Up ⬆️"https://www.linkedin.com/in/amitinddr/
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!