M
Mark J
I have a table like this (original cotains a row a 4000 cells)
CAR NUMBER TOTAL
Mazda 1
Mazda 7
Mazda 8
Volvo 4
Volvo 5
Skoda 5
Skoda 4
Skoda 7
How do i get a sum of cells with the same name, so you get something
like this.
CAR NUMBER TOTAL
Mazda 1 16
Mazda 7
Mazda 8
Volvo 4 9
Volvo 5
Skoda 5 16
Skoda 4
Skoda 7
CAR NUMBER TOTAL
Mazda 1
Mazda 7
Mazda 8
Volvo 4
Volvo 5
Skoda 5
Skoda 4
Skoda 7
How do i get a sum of cells with the same name, so you get something
like this.
CAR NUMBER TOTAL
Mazda 1 16
Mazda 7
Mazda 8
Volvo 4 9
Volvo 5
Skoda 5 16
Skoda 4
Skoda 7