Forum Discussion
Shanaya_98
Jan 01, 2024Copper Contributor
How do I get excel to calculate ticked boxes as a percentage
I have inputted check boxes in a table on excel from the Developer tab and I want, at the bottom of my table, for a formula to tell me the percentage of how much is completed. I have used the for...
PeterBartholomew1
Jan 01, 2024Silver Contributor
The error message tells you that cells B6:B36 are empty. This means that the controls have not been linked to cells in the correct range. Both the new 365 controls and the traditional form controls return TRUE/FALSE rather than 0/1 so the formula would need to read
= COUNTIF(checkmarks, TRUE) / COUNTA(checkmarks)