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.
Best Answer
This works with the formula sumif(). In your example the formula would be something like this: SUMIF($A$2:$A$22,A2,$B$2:B22).