Wednesday, April 9, 2014

yogi_Compute Grand_Total Of Tasks Completed And Running Sum Of Day_Totals And Part_Totals For An Open Ended Number Of Columns And Rows


                                         Google Spreadsheet   Post  #1595
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Apr-09-2014
post by Bruno Benitez: (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/WZtTmcntDdo)
Doing a summatory of a row plus all the preceding numbers on a column
Hello, im keeping tracks of the work being done per day, we have a finite amount of items to work on and i want to know what percentage of the total is being done.

my sheet looks basically like this:

date    |  john  |  carl  |  penny  |  total  |  grandtotal1/1/14  |  4     |  9     |  1      |  14     |   49    2/1/14  |  6     |  4     |  3      |  13     |
3/1/14  |  6     |  7     |  9      |  22     |


With the "Total" cells being defined as "SUM(B2:D2)" and so on, C3:D3, etc. and "grandtotal" being defined as SUM(E:E)

What i would want is to have a sum of all the totals until a date by separate, like

date    |  john  |  carl  |  penny  |  daytotal  | parttotal | grandtotal1/1/14  |  4     |  9     |  1      |  14        | 14        | 49    2/1/14  |  6     |  4     |  3      |  13        | 27        |
3/1/14  |  6     |  7     |  9      |  22        | 49        |

so i can call each day and get what percentage of the work has been done up to that date

---------------------------------------------------------------------------------------------------------------------------------------