Total Qty based on ID

[djfscouse]

Hi,

What I'm trying to accomplish is if the ID in column A appears more than once, total its value from column B to be displayed in column C.

Here is how far I've got but it does not work. I'm just missing how to total its column B value match with ID from column A.

Please Login or Register  to view this content.

Attached is my excel file with starting data on Sheet1 and showing the desired result on Sheet2

Thanks for any help,

David

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[walruseggman]

I think I like John's solution better, but here's what I have:

Please Login or Register  to view this content.

[djfscouse]

Thanks guys both VBA's are perfect.