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:D)

, formatted as %. Fill down.