Tuesday, December 6, 2011

yogi_Compute Running Total of Miles Run by Date From Data Submitted by Google Form

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
user SunSponge said:
Use form to populate / get running total on spreadsheet?
I have searched and looked at every example I can find, but still cannot get or understand how to get the running total via a form as described below. Believe me, I've looked and just gotten frustrated.
How do I use a Google form to populate a simple spreadsheet and calculate the new/current running total after each single entry is entered? 
Each trip entry needs to get entered, then update / add to the previous running total. The individual amount inserted into column "B" and added to the previous running total and placed in column "C".
Column "A" is the date, and I'd like this to automatically be the current date, unless a different date is entered into the form. If no specific data is entered, then the computer's current date is automatically entered into column "A". Can this be set up so that the date is either automatic or if a different date is entered via the form, this 'manual' date over-rides the automatic date?
Column "B" is where the individual amount goes from the form. 
An example is an individual entry from column "B5" adds to the previous total from column "C4" to get an updated "C5".
Here are the cell formulas that get this done via manual entry into the spreadsheet:
C3 formula: =B3
C4 formula: =C3+B4
C5 formula: =C4+B5
I need this to get updated by using a form that automatically updates the spreadsheet.
I cannot figure this out, have looked at many similar examples on thie help forum, but am kindly requesting help to figure this out.
Thank you in advance!


following is solution to the problem