I am using Office 2003 on Windows XP.

Suppose I have the following (hopefully it will line up):

ID Qty
232 50
232 50
232 50
628 10
628 10
550 63
728 82
009 14
009 14

Is there a formula I can use in the spreadsheet that will sum the quantities
(Qty) column, but only once for each ID? If so, could someone please post a
solution?

I could code something in VBA, but I'd prefer to write a formula. Can it be
done?

Thanks much in advance.