I am having some trouble and am new at this. I have a fillable document that I have completed minus (which I guess is the hardest part) the correct formula. I have made an audit for my company months ago using excel and have been doing it via paper for sometime, well about a year. I am not sure what to do about getting this formula right.

Here is what is going on

I have boxes that get an x marked if passing to be a value of 1. lets say there are 20 different boxes per section that can be marked, each with a value of 1.

Within each section I would like to give a score that would refect

a.) The sum

b.) The avg in percent

which both of these I have boxes ( seperate) in each section of the audit that are designated to this alone.

in the calculations section I have the formulas set up to the sum fillable boxes that are checked

More or less Im pretty sure that I need to give a value to x but I am not sure how to do this.

Thanks

PDFDUMMY