Hi,
Assuming the height range is in C1:C9.
Now array enter (Ctrl+Shift+Enter) the following formula in cell C11
=COUNT(IF((C5:C92)*(C5:C9<5),C5:C9))
Regards,
"old grey whiskers" wrote:
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
|