I'll assume you have your questions in column A, and your
answers (Y/N)in column B. In column C, use the formula =IF
(B1="Y",1,IF(B1="N",2)) then a "1" will be returned if
the answer is "Y" or a "2" if the answer is a "N". Then,
at the bottom of column C, simply add up the numbers.

Hope this helps.



-----Original Message-----

I am creating a performance chart for employees to fill
out. Below is an example of a set of questions they need
to complete, with a possible answer to each. My
spreadsheet is being designed to calculate a points
system
on multiple categories

1. How many appointments did you have? "2"
2. How many new appointments did you set? "1"
3. Did you follow up with active client groups, not yet
rented? "Y"
4. Have you made collection calls to clients that owe
money? "N"
5. Have you reviewed and replied to all your
emails? "Y"

I need a formula that will add up all the numeric
answers,
but also add the value for each question that has a "Y"
or "N" possible ansewr. So question 3, answered "Y" may
be
+3 towards the total. but question 5 may only be a +1
towards the total if answered "Y" or a -3 if "N"

please help!

Much Thanks!
Corey

.