Another Counting Question

[GrtArtiste]

I use a spreadsheet with a column (H) in which single digits (usually
0 through 6)
are entered beginning in row 11. The most recent entry is in row 804
and there
will be an unknown number of additional entries. I need a formula
which will
show the number of times that a certain value (for example, 2) has
been entered
in the column. In addition, it would be helpful if a second formula
could show the
result as a percentage of the total number of entries in the column.

Any tips on how to proceed? I’m using MS Excel 2003. Thanks for any
assistance.

GrtArtiste

 

[Don Guillett]

I use a spreadsheet with a column (H) in which single digits (usually
0 through 6)
are entered beginning in row 11. The most recent entry is in row 804
and there
will be an unknown number of additional entries. I need a formula
which will
show the number of times that a certain value (for example, 2) has
been entered
in the column. In addition, it would be helpful if a second formula
could show the
result as a percentage of the total number of entries in the column.

Any tips on how to proceed?  I’m using MS Excel 2003. Thanks for any
assistance.

GrtArtiste

Look in the help index for COUNTIF and AVERAGE

 

[GrtArtiste]

Look in the help index for COUNTIF and AVERAGE

Okay, I've used COUNTIF to account for all the cells in column H that
have values of 0 through 6, but I've been unable to account for the
one cell that has a value greater than 6. If I enter
=countif(h11:h1000,>6) it says the formula has an error. Is there a
way to account for that one cell or others that may occur? Thanks for
the reply.

GrtArtiste

 

[Claus Busch]

Hi,

Am Sun, 19 Feb 2012 06:50:08 -0800 (PST) schrieb GrtArtiste:

If I enter
=countif(h11:h1000,>6) it says the formula has an error. Is there a
way to account for that one cell or others that may occur? Thanks for
the reply.

try:
=COUNTIF(H11:H1000,">6")


Regards
Claus Busch

 

[Dave Peterson]

You could use:
=countif(h11:h1000,">"&6)
That way, you may find it easier to point at a cell that contains 6:
=countif(h11:h1000,">"&z99)
(where z99 contains 6)