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

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

regards,
driller
--
*****
birds of the same feather flock together..



"CMEC" wrote:

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