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   Jan-17-2014
post by Steven Kilpatrick (!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"

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!