Wednesday, July 11, 2012

yogi_Setup Computed Column In A Checkbook For Running Balance

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #620   Jul 11, 2012     www.energyefficientbuild.com.


user AnaMarquis said: (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/how-do-i/desktop/BP1aVW4xTA4)
Will Google Docs find the sum of a row for me? For each time I use a particular word in a row? Bookkeeping question
Here is a link to the spreadsheet template I am using. It is great except that I also need to categorize expenses and I can't seem to find a way to do that. For example, when I have a 'Phone Company' bill, each month I would enter the phone company bill and at the end of the year of entering my banking transactions I would like to be able to look at the sum for my total phone company expenses. https://docs.google.com/spreadsheet/ccc?key=0Apt36CUWUnQhdEdmMTBjRU10b2FpZlg0NnJ5ZV9lS2c#gid=3 
I tried the find function, thinking that it would at least point me to each time I used the words "Phone company" but it doesn't work that way and if it did I would still have to manually enter/compute the phone company expenses for each transaction to come up with the sum, vs being able to have google doc do the work for me. 
Thank you for any help you can offer, 
Ana
------------------------------------------------
following is a solution to the problem ... I have made H6:H a computed column which automatically and dynamically provides the Running Balance