software

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

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,quot;lt;=100quot;) will count subscriptions lt;= £100:00

=COUNTIF($B:$B,quot;lt;=200quot;)-COUNTIF($B:$B,quot;lt;=100quot;) will count subscriptions
gt;£100 and lt;= £200

Does this help?quot;Martin ©¿©¬ @REMOVETHIS.plus.comquot; wrote:

gt; Hi
gt; I have 2 columns
gt; A has a name and B has a subscription amount
gt; Would it be possible to sort by the number of persons subscribing
gt; under £100 - 200 - 300 - 400 - 500 and over 500 from which I would
gt; then make a graph/bar chart/pie etc
gt;
gt; This is my first attempt at this so please keep it simple please
gt;
gt; Martin
gt; ©¿©¬
gt;

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 quot;Field Settingsquot; and select quot;Countquot; under Summarize by. Then right
click the filed again, choose quot;Group and Show Detailquot;, choose quot;Groupquot;, 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 MVPlt;Martin ©¿©¬ @REMOVETHIS.plus.comgt; wrote in message
...
gt; Hi
gt; I have 2 columns
gt; A has a name and B has a subscription amount
gt; Would it be possible to sort by the number of persons subscribing
gt; under £100 - 200 - 300 - 400 - 500 and over 500 from which I would
gt; then make a graph/bar chart/pie etc
gt;
gt; This is my first attempt at this so please keep it simple please
gt;
gt; Martin
gt; ©¿©¬

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?--
bulaman001
------------------------------------------------------------------------
bulaman001's Profile: www.excelforum.com/member.php...oamp;userid=32264
View this thread: www.excelforum.com/showthread...hreadid=520106Look in help for the SUMIF function.

HTH,
Bernie
MS Excel MVPquot;bulaman001quot; gt; wrote in message
...
gt;
gt; Help;
gt; Could anyone help me regarding adding column cells that have text and
gt; be able to put a formula in a blank cell adding the total of cells
gt; within that column for a numeric total?
gt;
gt;
gt; --
gt; bulaman001
gt; ------------------------------------------------------------------------
gt; bulaman001's Profile: www.excelforum.com/member.php...oamp;userid=32264
gt; View this thread: www.excelforum.com/showthread...hreadid=520106
gt;