CountIF Help needed

Hope someone can help me! I have a wide sheet with a gold score and several test scores, a row of formulae telling me if the candidate was right or wrong. I can get the total scores using CountA and Countif formulae. But then I want to count only some of the scores so only questions Q1 Q5 and Q8 make my "Priority Questions".


Q1 Q2 Q3 Q4 Q5 Q6 Q7 Q8
Y Y Y Y Y Y Y Y
N Y N Y Y N N Y
FALSE TRUE FALSE TRUE TRUE FALSE FALSE TRUE

I have tried to exclude using Countif(A1,A5,A8,"true") but it didn't work :-(

Thanks,
Kev

Hi,

Provided Q1 to Q8 are located in row 1
and TRUE FALSE in row 3 ...

Please Login or Register  to view this content.

HTH
Carim

Thanks Carim, that worked a treat and I learned a function as a bonus.
Kev

Glad your problem's fixed

Thanks for the feedback

Carim