Sort subs. by amount

[Martin ©¿©¬]

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
©¿©¬

 

[Guest]

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?

 

[Bernie Deitrick]

Martin,

Use a pivot table. Select your data table with the subscription amounts, then use Data / Pivot
Table... and hit Finish.

Then drag the Subscription amount button to both the row field and the data field, and right click
the row field button, select "Field Settings" and select "Count" under Summarize by. Then right
click the filed again, choose "Group and Show Detail", choose "Group", then use 100 as the starting
value, 500 as the ending value, and 100 as the step value, and you will get your summary.

HTH,
Bernie
MS Excel MVP

 

[bulaman001]

Help;
Could anyone help me regarding adding column cells that have text and
be able to put a formula in a blank cell adding the total of cells
within that column for a numeric total?

 

[Bernie Deitrick]

Look in help for the SUMIF function.

HTH,
Bernie
MS Excel MVP