Another Counting Question

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
 
D

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
 
G

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
 
C

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
 
D

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top