Friday, January 17, 2014

yogi_Given Project Completion Stages And Associated Tasks Compute Projection Completion Percentage For Each Stage Per Specified Rule

                                          Google Spreadsheet   Post  #1487
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-17-2014
post by Steven Kilpatrick (http://productforums.google.com/forum/#!mydiscussions/docs/1J9Lz01WC_M)
summing cells based on filling in cell or clicking checkbox
 am building a to-do list for a project. I would like to sum a column based on a box being filled or a checkbox being checked. 

If I have 4 things to do, one checkbox or cell being filled it would be 25%, if 2 checked or filled - 50%... and so on. Can this be done? It is possible in excel using "IFTRUE" and "IF FALSE"
---
https://docs.google.com/a/gradesfirst.com/spreadsheet/ccc?key=0AiQyflmMyBM3dHBtdW8zQVR4SkFqSW1WaEFhLXB3VEE&usp=sharing

as you  can see, I have 2 stages with a few tasks in each. I need when each are checked, to sum into the percentage for the stage. 2 done = 50%. When all are checked, the project is 100% complete. Make sense? THanks!
-----------------------------------------------------------------------------------------