Formula conundrum calculating a percentage average...help!
 

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

Formula conundrum calculating a percentage average...help!
 

In B70 ---

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


"CMEC" wrote in message
...
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

Formula conundrum calculating a percentage average...help!
 

B1 (not B11) contains value to be checked

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

format cell as %

"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

Formula conundrum calculating a percentage average...help!
 

Also, format the cell to percentage.


"Gary" wrote in message
...
In B70 ---

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


"CMEC" wrote in message
...
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

Formula conundrum calculating a percentage average...help!
 

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