Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |