Counting the number of values in a list between two specified valu

G

Guest

I have 30 entries in a list which are the heights of students in my class in
cm. I want to plot a bar chart of this data so the spreadsheet is arranged to
show the data as numbers of students with heights between certain values eg 3
students between 131 and 135 cm, 4 between 136 and 140 cm, 2 between 141 and
145 cm etc. Which formula do I use to get excel to automatically calculate
the numbers iof students between these values? I have tried combinations of
SUM and IF to no avail. Can anyone help.
Thanks.
 
B

Bob Phillips

=SUMPRODUCT(--(rng>=13),--(rng(<=135)

etc.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count the number of values in a list that meet certain criteria 1
counting the last 3 values not equal to x in a list 3
Calculating the number of values between specified ranges 1
Creating A List of Items Between Two Numbers 2
Counting unique values in a list generated with the OFFSET functio 3
Having Excel calculate the number of times a range of values occur 2
How can I calculate the average of a list of time values in excel 2
How to count the number of 'values' in a cell 1

Top