Total by Invoice Number

[VJ]

Is there an easy way to get totals by a group number in Excel 2003?

I've a table in Excel like this:

s1010 105
s1010 20
s1013 40
s1014 80
s1014 88
s1014 82

I'd like to add another total column for each number:


s1010 105 125
s1010 20 125
s1013 40 40
s1014 80 250
s1014 88 250
s1014 82 250

I don't know how many lines each number will have or can have - in
other words, S1013 has only one line but next run, it may have 10
lines. Does this make sense? Any easy way to go from first to the
second.

 

[Jordon]

Pivot table?

 

[dranon]

Say the data is in cells A1:B6

In cell C1 put:

=SUMIF(A$1:A$6,$A1,B$1:B$6)

Copy C1 to C2 through C6.

 

[VJ]

Great - this works like a charm - appreciate your help.
Does this work in Excel 2003? It is working on 2007 but the end user
has 2003 - I'd like to make sure before I share with her.

 

[Pete_UK]

Yes, it will work with XL 2003.

Pete