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?

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
    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.


    Amit WadhwaniSmartsheet CoE, Ignatiuz Software, Exton, PA

    Best Regards

    Amit Wadhwani, Smartsheet Community Champion

    Smartsheet CoE, Ignatiuz Software, Exton, PA

    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!