View Single Post
  #2   Report Post  
Gary's Student
 
Posts: n/a
Default

A pivot Table (pulled down from Data) will generate the sum for each unique
entry in the first column.
--
Gary's Student


"Mosqui" wrote:

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