Do you want the frequency or the count? Your descriptions sounds like you're
looking for the count. Assume the data are in A1:A100.
=COUNTIF(A1:A100,"<=200000") will count the number of populations less than
or equal to 200,000 etc.
If you're looking to create a frequency distribution, then see here for info
on the FREQUENCY function:
http://www.meadinkent.co.uk/xlfreq.htm
Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.
"Blackhawk.34" wrote:
I have 22 different populations taken from a poll. I want to calculate the
frequencies by using the less than or equal to function. For example the
number of people that live in of 200,000 or less, then 100,000 or less and
down the line. I only have one column, that of the different populations.
--
blackhawk