You should consider using a Pivot Table:


http://www.contextures.com/xlPivot07.html#Unique



--
Gary's Student


"jim mcgrath" wrote:

Hello,
I have 2 columns I want to analyse.
Col. A has (3 digit numerical) codes, & col. B has corresponding numerical
values.
I'm looking for a formula to give me a sum of the values for each code.
Help please.

Jim