Macro to calculate total quantities
 

My data consists of part #'s from a bill of material. The spreadsheet
includes part#, area#, part description, and quantity of each part# in each
area#.

Part# Area# Part Description Qty in
Area
1A34 1000 widget 3
1A34 2000 widget 7

What I am looking for is a macro to go thru the entire bill of material
(1500 parts or so) and add up the total quantity for each part #.

I would appreciate any help you may have.

Thank you