Help with Formulas
 

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

Help with Formulas
 

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

Help with Formulas
 

Thanks, thats what I was trying, but I had it backwards and too many brackets
so wasnt' working for me... DUH!!!

"Pete_UK" wrote:

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

Help with Formulas
 

Glad to be of help - thanks for feeding back.

Pete

On Jul 3, 12:58*am, Nadine wrote:
Thanks, thats what I was trying, but I had it backwards and too many brackets
*so wasnt' working for me... DUH!!!