Hi all,

Really need your help on how to set a formula to count the
product name appear in how many time.

example,

Cell A1
Product A
product B
Product C
Product A
Product A
product B

total product A = 3 times
total product B= 2 times
total product c = 1 times

thanks for help