Counting data problem

  • Thread starter Thread starter rdusseau
  • Start date Start date
R

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(D2:D17, "50:80") o
=COUNTIF(D2:D17, ">=50<80")

Any thoughts or help would help greatly.

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

=COUNTIF(D2:D17,">50")-COUNTIF(D2:D17,">79")
OR
=SUMPRODUCT((D2:D17>50)*(D2:D17<80))

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

=COUNTIF(D2:D17,">=50")-COUNTIF(D2:D17,">80")
OR
=SUMPRODUCT((D2:D17>=50)*(D2:D17<=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(D2:D17, "50:80") or
=COUNTIF(D2:D17, ">=50<80")

Any thoughts or help would help greatly.

Thanks,
Rob
 
Back
Top