I am creating an audit workbook with a number of worksheets. The primary
worksheet includes questions and a column for the auditor to select Yes, No
or N/A. I'd like to create a worksheet that "scores" the facility visited. In
order to do that, I need to count the number of No and N/A responses
automatically. To make it a bit more challenging, there are nine distinct
sections within the primary audit worksheet, and I want to score each section
separately and then take the total of each of those, add them together and
create a total score. First, I need a formula to automatically calculate the
total of No's and N/A's in each section, then a formula to add all of those
together, and lastly a formula to capture that data on the scoring page and
automatically apply it to the cells on that page that total those numbers by
section and total report (clear as mud, right?). I'd greatly appreciate any
help you cam provide. Thanks.
--
Bill