Sum by group horizontally

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



jose97's picture
Joined: Feb 8 2017 - 5:45am
Last seen: 4 years 6 months ago

0 Answers:

No answers yet