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
|