Hi Mel

Try putting a list of the destinations you need to total in say cells
W1:W10 then in cell X1 enter
=SUMIF(K:K,W1,L:L)
Copy formula down through cells X2:X10

Make the range in W long enough to deal with each of your required
locations


--
Regards

Roger Govier


"Mel" wrote in message
...
I have data in rows 3 to 49 and columns A to U. In column L are names
of
destinations. In Column K are weights delivered to those destinations.
I need
a formula to give me the total weight delivered to each of those
destinations. Can anyone help please?!