Sum by group horizontally

[jose97]

I got a request and I dont know how to properly start.

To simplify I need to calculate total of ID, NAME based in the rows.
The cell for Total mus be one for every ID even if it has more than one row.

This is a example to what i need to accomplish.


Tabla 1

ID	Name	price	total
10	John	5	10
10	John	3
10	John	2
30	Steve	5	20
30	Steve	15