excel sum formula

  • Thread starter Thread starter Brendan
  • Start date Start date
B

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
 
Brendan said:
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
Click to expand...

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.
 
Brendan

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

Andy
 
Back
Top