If you want to use a formula:

="P = " & COUNTIF(A3:A15, "P")

I used rang A3:A15, but you can use whatever range the criteria is in.
CountIf
concatenated to each rating, i.e. "PG = ", PG13 = ", etc. will give you an
output
like P = 5, PG = 11, etc. You need a formula for each rating code in their
individual cells.


"Bishop" wrote in message
...
I have a single column that contains multiple entries of 7 different
ratings:
P, PG, PG13, R, NC17, X, Unrated. I'm trying to initialize a Summary
userform with the sum of each of these and assign these sums to a label
for
each of the ratings. I thought about Sum or Count but I can't figure out
the
best way to extract all the entries for each rating, get a total and
assign
it to a variable. Any ideas?