If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Percentage formula needed
I have not used Excel formulas for a while (need to take a refresher course)
but in the meantime I am in need of the formula that will calculate the percentage below correctly when I enter more numbers in the response count column. Response percent column is C and response count column is D. Answer Options Response Percent Response Count Always 25.0% 3 Usually 50.0% 6 Sometimes 16.7% 2 Rarely 8.3% 1 Never 0.0% 0 Thank you---I really appreciate any help. |
#2
|
|||
|
|||
Percentage formula needed
MJM wrote:
I have not used Excel formulas for a while (need to take a refresher course) but in the meantime I am in need of the formula that will calculate the percentage below correctly when I enter more numbers in the response count column. Response percent column is C and response count column is D. Answer Options Response Percent Response Count Always 25.0% 3 Usually 50.0% 6 Sometimes 16.7% 2 Rarely 8.3% 1 Never 0.0% 0 Thank you---I really appreciate any help. C2 is =D2/SUM(D) , formatted as %. Fill down. |
#3
|
|||
|
|||
Percentage formula needed
I tried what was suggested and it did not work. My total number is 38
participants so I need to know what percentage for the number of people who answered in each response. Thanks "smartin" wrote: MJM wrote: I have not used Excel formulas for a while (need to take a refresher course) but in the meantime I am in need of the formula that will calculate the percentage below correctly when I enter more numbers in the response count column. Response percent column is C and response count column is D. Answer Options Response Percent Response Count Always 25.0% 3 Usually 50.0% 6 Sometimes 16.7% 2 Rarely 8.3% 1 Never 0.0% 0 Thank you---I really appreciate any help. C2 is =D2/SUM(D) , formatted as %. Fill down. |
#4
|
|||
|
|||
Percentage formula needed
Where does 38 come from? In the table you've given us, you show 3+6+2+1+0 =
12 responses. How does this turn into 38? Also, responses of "it did not work" are very unhelpful, and can only lead to more questions. Telling us what result you got, and what you wanted instead, will save you a lot of time. Regards, Fred. "MJM" wrote in message ... I tried what was suggested and it did not work. My total number is 38 participants so I need to know what percentage for the number of people who answered in each response. Thanks "smartin" wrote: MJM wrote: I have not used Excel formulas for a while (need to take a refresher course) but in the meantime I am in need of the formula that will calculate the percentage below correctly when I enter more numbers in the response count column. Response percent column is C and response count column is D. Answer Options Response Percent Response Count Always 25.0% 3 Usually 50.0% 6 Sometimes 16.7% 2 Rarely 8.3% 1 Never 0.0% 0 Thank you---I really appreciate any help. C2 is =D2/SUM(D) , formatted as %. Fill down. |
#5
|
|||
|
|||
Percentage formula needed
How did you calculate the percentages in the column, "Response
Percent"? Is your total number always 38? |
#6
|
|||
|
|||
Percentage formula needed
Thank you Fred for the input, I appreciate it, as I am new on these boards.
I actually figured out out myself and it was quite simple, as I knew it would be. "Fred Smith" wrote: Where does 38 come from? In the table you've given us, you show 3+6+2+1+0 = 12 responses. How does this turn into 38? Also, responses of "it did not work" are very unhelpful, and can only lead to more questions. Telling us what result you got, and what you wanted instead, will save you a lot of time. Regards, Fred. "MJM" wrote in message ... I tried what was suggested and it did not work. My total number is 38 participants so I need to know what percentage for the number of people who answered in each response. Thanks "smartin" wrote: MJM wrote: I have not used Excel formulas for a while (need to take a refresher course) but in the meantime I am in need of the formula that will calculate the percentage below correctly when I enter more numbers in the response count column. Response percent column is C and response count column is D. Answer Options Response Percent Response Count Always 25.0% 3 Usually 50.0% 6 Sometimes 16.7% 2 Rarely 8.3% 1 Never 0.0% 0 Thank you---I really appreciate any help. C2 is =D2/SUM(D) , formatted as %. Fill down. |
Thread Tools | |
Display Modes | |
|
|