Google Spreadsheet Post #1487
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jan-17-2014
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
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= 0AiQyflmMyBM3dHBtdW8zQVR4SkFqS W1WaEFhLXB3VEE&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!
No comments:
Post a Comment