Hi,

Assumed your data range start from Sheet1, A1 to B5

In your new sheet, try...

=SUMIF(Sheet1!$A$1:$A$5,A1,Sheet1!$B$1:$B$5)




"Mosqui" wrote in message
...
I'm not sure how to do this.
A B
34-f-r 33
34-f-r 56
34-f-k 44
34-f-t 99
34-f-t 82

I want to add column B if A is the same, so I want to make anothe sheet with
cells in column A no repeated but all the values in column B added.

A B
34-f-r 89
34-f-k 44
34-f-t 181

Thanks and congratulations to all the helpers.

Martin