Total by Invoice Number

  • Thread starter Thread starter VJ
  • Start date Start date
V

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Total by Invoice Number 1
Even Distribution Formula 2
calculating a total amount 7
Pivot: totals in the next column 6
How can I write this 'simple' formula 8
Find Last Date Invoiced for Each Customer 3
Partywise BreakUp Report 3
If Multiple Criteria 1

Back
Top