How to Sum up multiple similar entries of a specific column in a New column

Highlighted
Occasional Visitor

Hi Community,

 

I have an Excel sheet that has multiple similar entries under a specific column and I am trying to count the number of occurrences of my unique values in a new column i.e. on Column C. I would appreciate support in this regard. Enclosed the excel for your reference and I need the data in column C.

 

 

 

Bests,

Dhruba005

1 Reply
Highlighted

@dhruba005 solution attached