excel sum formula

[Brendan]

Hi all,

I have an excel worksheet with a little over 4000 rows..
Column A is a customer number and column B stores the
amount they have spent in the last month

A customer numeber may appear many times in consecutive
order.

What I need is to sum up the amount each customer spent
and start again at 0 when a new customer numeber is
encountered

Thanks in advance

 

[Anon]

Hi all,

I have an excel worksheet with a little over 4000 rows..
Column A is a customer number and column B stores the
amount they have spent in the last month

A customer numeber may appear many times in consecutive
order.

What I need is to sum up the amount each customer spent
and start again at 0 when a new customer numeber is
encountered

Thanks in advance

Have a look at Subtotals, which you find on the Data menu and which is
described under "subtotals, data summary" in Help. Basically, the wizard for
this allows you to insert subtotal rows every time there's a change in a
list - in your case every time the customer number changes.

 

[AndyB]

Brendan

I would use a pivot table. This would do what you want quickly and easily.

Andy