I was wondering if anyone knew how I could sort numbers and count how
many fall into a certain range?

I have a bunch of cheque values, and want to be able to count how many
are 0-100, 101-200, 201-300 etc...

Ultimately, I want to be able to create a graph showing what portion of
all the values fall into each range.

Does anyone know how I should go about this?

Also would be interested in how to do a sum of all the values in The
range and do a similar graph.


--
Ender
------------------------------------------------------------------------
Ender's Profile: http://www.excelforum.com/member.php...o&userid=33258
View this thread: http://www.excelforum.com/showthread...hreadid=530810