And another option for the collection ...

=SUMPRODUCT((A1:A500=170)*(A1:A500<=175))

Regards

Trevor


"old grey whiskers" wrote in
message ...
How can I count occurances in a range of values. Eg If I have a class of
students ranging from 150cm to 190cm height, what is the formula in Excel
to
count how many people are between 170 and 175 cm. How can I count values
greater than and less than in one operation?
--
old grey whiskers