You don't need the ATP - this will give you the %age of A in column A:

=COUNTIF(A$1:A$390,"A")/COUNTA(A$1:A$390)

which you can copy down and just change the "A" to "B" etc. Better
still, put A, B, C etc in cells G1, G2, G3, and then put this formula
in H1:

=COUNTIF(A$1:A$390,G1)/COUNTA(A$1:A$390)

format as %age, then copy the formula down. Copy across to get results
for adjacent columns.

Hope this helps.

Pete

On Jul 2, 11:36*pm, Nadine wrote:
Hi,

Have several columns, cell values will contain a letter - *A, B, C or D
Trying to create a summary of results, what is the percentage for each value
i.e - total count values in the column - got that as counta(a1:a390)
but now want to summarize the cell values
A = 57%
B = 13%
C= 10%
D= 10%

Tried the Tool Analysis pak, but not familiar with it, tried a couple of the
analysis types - *guess range can only contain numbers. *But still reading
the help on that tool, to see if any of those will work....do any of those
functions work with letters for the cell values. *
thanks