Counting data problem

[rdusseau]

Hi all... I am having a slight problem.

I have a list of test scores... 82, 86, 27, etc... I am trying to coun
the number of scores within a certain range. For example, I want t
know the number of scores between 50 and 80.

I have made many attempts and may be shooting off into the dark... my
most recent attempt was something like: =COUNTIF(D217, "50:80") o
=COUNTIF(D217, ">=50<80")

Any thoughts or help would help greatly.

Thanks,
Ro

 

[BenjieLop]

Try this ...

=countif(D217,">50")-countif(D217,">80")

 

[RagDyer]

If you want numbers *between* 50 and 80, try this:

=COUNTIF(D217,">50")-COUNTIF(D217,">79")
OR
=SUMPRODUCT((D217>50)*(D217<80))

If you want to *include* 50 and 80, try this:

=COUNTIF(D217,">=50")-COUNTIF(D217,">80")
OR
=SUMPRODUCT((D217>=50)*(D217<=80))
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Hi all... I am having a slight problem.

I have a list of test scores... 82, 86, 27, etc... I am trying to count
the number of scores within a certain range. For example, I want to
know the number of scores between 50 and 80.

I have made many attempts and may be shooting off into the dark... my
most recent attempt was something like: =COUNTIF(D217, "50:80") or
=COUNTIF(D217, ">=50<80")

Any thoughts or help would help greatly.

Thanks,
Rob