Count Number of Occurrences of Each Value in a Column

mgilkessmith

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.

Amit Wadhwani

Hi @mgilkessmith

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

https://www.linkedin.com/in/amitinddr/