Logic test

[yurant]

Hi there, I need some help with an IF formula I'm trying to use to tabulate questionnaire results.

I have a "header" row where I have the question, and then below that row are "sub" rows where I placed what the correct response are, yes (cell C3), or no (cell C4).
Under that section I have tabulated the responses from those who responded to the questionnaire.
JOHN is the first responder, and since he responded correctly, I have an "x" next to his yes cell (C7). The value of his correct response is 2 points and he gets zero if he has an incorrect response, (his no cell is C8).

Since he got the question right he should receive 2 points, and here's the IF formula I used to get the 2 to appear in cell C9:

=IF(AND(C$3=C7,C$4=C8),"2","")

It looks great and works great, but the problem is that when I try adding the points in row 9 (all the correct responses), Excel seems to be taking these values as text and I consequently do not have JOHN's score as being 2, but instead it comes up as 0.

What formula should I be using in order to be able to add JOHN's correct responses?

Thanks!!!

 

[Smitty]

Welcome to the Board!

Lose the quotes around the 2.

HTH,

 

[yurant]

Smitty..... Thank you!!!!!

Now I know that quotes means "treat this a non-numerical value"

Muchas gracias, you really made this a painless and enjoyable Sunday!