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