## 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

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Apr-09-2014
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

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