Another Counting Question

  • Thread starter Thread starter GrtArtiste
  • Start date Start date
G

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
 
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
Click to expand...

Look in the help index for COUNTIF and AVERAGE
 
Look in the help index for COUNTIF and AVERAGE
Click to expand...

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
 
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.
Click to expand...

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


Regards
Claus Busch
 
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)
 
Back
Top