Formula conundrum calculating a percentage average...help!

[Guest]

I'm pretty new to anything more complicated than a simple formula, so please
bear with me.

Here's what I'm trying to do (unsuccessfully so far):

I have a cell, let's call it B11, that contains a numerical value (0,1,2, or
whatever).

In the column beneath the cell, I have a further 60 cells (say B7 to B66)
that will also contain a numerical value (0,1,2, or whatever).

At the bottom of that column, say in cell B70, I want to place a formula
that will calculate the percentage average of cells from the range B7 to B66
that exactly match the value in cell B11. (I.e., if 6 of those 60 cells had a
value that matched the value in cell B11, I should get 10% in B70, 12 out of
60 would give me 20%, etc.)

I haven't figured it out yet, so please help guys

TNX

 

[Gary]

In B70 ---

=(COUNTIF(B7:B66,B11)/COUNTA(B7:B66))

 

[Guest]

B1 (not B11) contains value to be checked

=COUNTIF(B7:B66,B1)/COUNT(B7:B66)

format cell as %

 

[Gary]

Also, format the cell to percentage.

In B70 ---

=(COUNTIF(B7:B66,B11)/COUNTA(B7:B66))

 

[Guest]

on automatic mode, maybe not this one for sure....

=(COUNTIF(B7:B66,B11)-1)/COUNTA(B7:B66)

regards,
driller