Add total

[smash123]

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.

[[email protected]]

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)

[smash123]

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