Create Percentage Based off # of Checkboxes Checked
1) Creating a percentage to tally how much out of each section is checked completed.
2) Then also need to setup a formula to do the same for the overall sheet including all subheaders.
This is the formula I have so far for the individual subheader sections. But I keep getting Invalid Operation errors. Not sure what I'm missing here. Screenshot attached for further context.
=COUNTIF(Done3:Done8, 1) / (COUNTIFS(Done3:Done8, 0, NOT(ISBLANK(@cell) + (COUNTIF(Done3:Done8, 1)))))
Help Article Resources
Check out the Formula Handbook template!