Column A: Name of buyer
Column B: Product
Column C= Price of product.
Example:
John Apples 3
Jane Pears 4
John Grapes 5
Now I want to include a TOTAL, which sums the amount they have spent on all products
Example:
John Apples 3
Jane Pears 4
John Grapes 5
John TOTAL 8 (3+5)
But I want to continue adding rows, so it may look like this later:
John Apples 3
Jane Pears 4
John Grapes 5
John TOTAL 15 (3+5+7)
John Carrots 7
My problem is, how to set up the SUM formula. Obviously you cannot sum a list of values that includes the sum itself, so it must add up the range, excluding itself.
Best practices would put the TOTAL at the beginning of the range or at the end of the range, but then i wouldn't need to post this
Thanks!