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

  • Amit Wadhwani
    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 WadhwaniSmartsheet CoE, Ignatiuz Software, Exton, PA

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

    Best Regards

    Amit Wadhwani, Smartsheet Community Champion

    Smartsheet CoE, Ignatiuz Software, Exton, PA

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


    Did this answer help you? Show some love by marking this answer as "Insightful 💡" or "Awesome ❤️" and "Vote Up ⬆️"

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!