I want to give each item going down in rows a rating, 1, 2, or 3.

I want to at the top of that column to add how many 1's, 2's and 3's there are and give a percentage.

I don't know how to write macros, so is there an easy way to do it?

Ex:

1's = 25%
2'S = 25%
3's = 50%


item A - 2
item B - 3
item C - 3
item D - 1

I'm just a casual user but the COUNTIF function should work.

=COUNTIF(Range, criteria)

for your example below

=countif(B1:B4, "1")/5 format that as a percentage or multiply by 100. Repeat for "2" and "3"

Something like this?


Done with the below formula


You could make the data range a table, and reference the table column & not have to adjust your formulas as new rows are added

Thank you guys! The forum comes through again!