Martin,
You could use the COUNTIF function to give number of payments
in a given range:

0-100
101 -200
201-300
etc

An example:

=COUNTIF($B:$B,"<=100") will count subscriptions <= £100:00

=COUNTIF($B:$B,"<=200")-COUNTIF($B:$B,"<=100") will count subscriptions
£100 and <= £200

Does this help?


"Martin ©¿©¬ @REMOVETHIS.plus.com" wrote:

Hi
I have 2 columns
A has a name and B has a subscription amount
Would it be possible to sort by the number of persons subscribing
under £100 - 200 - 300 - 400 - 500 and over 500 from which I would
then make a graph/bar chart/pie etc

This is my first attempt at this so please keep it simple please

Martin
©¿©¬