yogi_Formula To Show Total On Last Entry For Multiple Same Entries

Google Spreadsheet   Post  #2273

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Nov-02-2017

question by: -KMac-

https://productforums.google.com/forum/?utm_medium=email&utm_source=footer#!topic/docs/2zZzynBgUv4;context-place=forum/docs
Formula to show total on last entry for multiple same entries

I have a form that takes input from users on people doing stuff.  The simple idea is that I can get the data into a sheet and have it provide a sum total on the last item they entered.  I have found a method to keep the sheet sorted on each edit so that the sheet stays in order after each entry.  However I cannot seem to find a way to provide a sum at the end of each entry so I can show one total.  The end plan is to be able to display with a table that each person can select their name and it display what the ordered, cost and one total.  Reference the picture below and link to the spreadsheet.

https://docs.google.com/spreadsheets/d/1fWB6_ghcST_X7RYKboR7Bca2lRNm1vN7qz0n-g1Kp4g/edit?usp=sharing

person 1	item 1	$5.00	$5.00	<-- Where you have people ordering multiple items, but need a subtotal on the last entry.	person 1	item 1	$5.00
person 1	item10	$8.00	$13.00		person 1	item10	$8.00
person 1	item 3	$4.00	$17.00		person 1	item 3	$4.00
person 1	item 15	$9.00	$26.00		person 1	item 15	$9.00
person 1	item 33	$11.00	$37.00		person 1	item 33	$11.00	$37.00
person 2	item 2	$6.00	$43.00	--> I would prefer a formula that only shows a total at the last entry for each person.	person 2	item 2	$6.00
person 3	item 8	$7.00	$50.00		person 3	item 8	$7.00
person 2	item 10	$8.00	$58.00		person 2	item 10	$8.00
person 2	item 4	$5.00	$63.00		person 2	item 4	$5.00
person 2	item 27	$10.00	$73.00		person 2	item 27	$10.00
person 2	item 30	$2.00	$75.00		person 2	item 30	$2.00	$38.00