View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
nadine nadine is offline
external usenet poster
 
Posts: 216
Default 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