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
---------------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment