Total by Invoice Number
 

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.

Total by Invoice Number
 

On Oct 7, 5:26*pm, VJ wrote:
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.

Look in the help index for SUMIF and post back with your formula and
ask if you want only unique for each number