Let's say I have a long list of clients in one column of a Numbers table, most of them occurring multiple times, and in the adjacent column are amounts due for services received, as depicted below. What is the easiest way to automatically add up all the amounts for each client and have them appear either in a third column or in a new table next to his or her name? That is, for
Ava I would like the total of
300 + 800 + 1200 + 1600 = 3900 to appear somewhere next to her name, for
Chloe it should be
450 + 950 = 1400, and so on.
Ideally, it should require as little maintenance as possible. For instance, if a new client is added to the list, a new entry/row should automatically appear in the third column/new table with that person's name and the sum of all their amounts.