Add total
 

Hi all!

Want to know if there is any faster way in excel on solving my LONG
problem. I have a worksheet as following:

1, $3
1, $2
1, $1
2, $5
2, $4
3, $4.50

P.S. In actual worksheet is D1 contains '1' and I1 contains '$3'

The first column is invoice number and the second column is amount. My
actual worksheet has over 5000 lines of those data. My work is trying
to get the total of each invoice. It should look something like this:

1, $6
2, $9
3, $4.50

I'm not sure this there is a build in function in excel on doing this
or this must done by programming the excel. If you can think of any
way. Please let me know and thank you very much on reading my post.


--
smash123
------------------------------------------------------------------------
smash123's Profile: http://www.excelforum.com/member.php...o&userid=29974
View this thread: http://www.excelforum.com/showthread...hreadid=542888

Add total
 

Quickest way would be a pivot table report (data menu, then the pivot
table option - follow the wizard, then drop the invoice number heading
to the left hand side, and the invoice amount to the middle - job done)

Add total
 

Thank you all! I have used SumIf function. It is easiler for me to do.
You guys saved me whole week of work. Thanks!


--
smash123
------------------------------------------------------------------------
smash123's Profile: http://www.excelforum.com/member.php...o&userid=29974
View this thread: http://www.excelforum.com/showthread...hreadid=542888