percent of times data shows in a column

**adamsj** · 03-12-2007, 03:39 PM

I need help with the formula that will give the percent of times a number is shown in a column. The numbers are
0-9 and at the bottom I need to calculate the number of times each number is in the column.

**adamsj** · 03-12-2007, 03:52 PM

I need to get the formula that will find the percent of times the number 0-9 are present in a column.

**VBA Noob** · 03-12-2007, 04:00 PM

Hi,

Please read the rules re duplicate posts

http://www.excelforum.com/showthread.php?t=591596

this might help. Say data in Col A then enter this in B1 and drag down

=COUNTIF(A:A,ROW()-1)/COUNTA(A:A)

VBA Noob

**adamsj** · 03-12-2007, 04:40 PM

I don't understand. My column is C4:C96. The numbers in the column are any number 0-9. At the bottom I need to calculate the percentage of times, ie. the number 3 is in the column. Thanks.

**rbhedal** · 03-12-2007, 04:45 PM

use this formula: =countif(c4:c96,3)

that will do it for you.

**adamsj** · 03-12-2007, 05:04 PM

Is there a way for the answer to show as a percent? Right now if I try to change it to a percent, it goes from 7 being my answer to 700% and it should be 7%. Also, when I add all 10 of my answers together it comes to 93%, why not 100%. What am I doing wrong?