=COUNTIF(AgeRange,"="&170)-COUNTIF(Range,""&175)
for an inclusive count.
=COUNTIF(AgeRange,""&170)-COUNTIF(Range,"="&175)
for an exclusive count.
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?
|