I might do this with a macro but you may benefit from looking in the help
index for
COUNTIF

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bill638" wrote in message
...
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