help with percentage formula

I have composed a spreadsheet that includes a column that attributes a grade to each row/item: 1,2,3 or 4.
I need to find a formula that will allow me to display a total for each grade, in overall percentage terms, i.e.:

(column)
.. 4 .......... (cell) 4=30%
.. 4 .......... (cell) 3=20%
.. 4 .......... (cell) 2=20%
.. 3 .......... (cell) 1=30%
.. 3 ..........
...2
...2
..1
..1
..1

thanks for taking the time to read this.

Assume the range you want to average is A1:A100. Also assuming that in Cells C1:C4 you have the options listed

In D1:D4...

=COUNTIF($A$1:$A$100,C1)/COUNT($A$1:$A$100)

Hope that helps...
John

Thanks John, but I think I have been unclear…the column exists as input data (always 1,2,3 or 4), and the four cells would individually contain formula to calculate the respective proportion of each grade, in percent. So the occurrence of the figure 4 was, say, 40% 2 was 10%...etc

Ta

......bump

Originally Posted by pumperley

Thanks John, but I think I have been unclear…the column exists as input data (always 1,2,3 or 4), and the four cells would individually contain formula to calculate the respective proportion of each grade, in percent. So the occurrence of the figure 4 was, say, 40% 2 was 10%...etc

Ta

Asin

=COUNTIF(C$1:C$100,C1)/COUNT(C$1:C$100)*100

?

if not, then you need to re-explain.

---

Originally Posted by pumperley

Still haven't managed to find the solution...thanks for the input Bryan!
I'll try to explain better..


Each row has a column identifying an individual of a specific product type...say....bananas.
Each banana, is attributed an identifying number in column A (in reality there will be around 150)
In column b, each individual is attributed a grade: 1,2,3 or 4 (every numbered item will be graded 1,2,3 or 4).

Clmn1 Clmn2
Banana 1 grade 2
Banana 2 grade 2
Banana 3 grade 3
Banana 4 grade 4
Banana 5 grade 1
Banana 6 grade 4
Banana 7 grade 1
Banana 8 grade 3
Banana 9 grade 2
Banana 10 grade 1


I want summary cells (one for each of the four grades) that will display the frequency of each grade, as a percentage of the total bananas. So using the above data, the summary cell for grade 1, would contain a formula
which would calculate the answer - 30%. The summary cell for grade 4 would contain a formula which would calculate the answer - 20%, and so on.

Thanks for taking the time, and fingers crossed!

Seems to be a popular theme for this weeks homework.

Having broken your data out to 4 columns, A to D, rows 1 to 10

in E1 put

=IF(COUNTIF(D$1:D1,D1)>1,"",COUNTIF(D$1:D$10,D1))

in F1 put

=IF(NOT(ISNUMBER(E1)),"",E1/SUM(E$1:E$10)*100)

and formula-fill those down the 10 rows.

You can omit the *100 and format column F as Percentage if yyou wish.

hth
---