b1kerch1ck
Programmer
Hi,
This is driving me nuts. Sorry if it's a repeat question but I can't find this one in the forum.
I am grading exams. I have two columns, one with the correct answer and one with the answer on the exam. It's a multiple choice test so the answers are just letters.
At the bottom of the second column, I want a count of correct answers. This should be easy...and I thought CountIf would do it, but it seems to need a fixed value to reference, and can't look at other cells.
Is there a function in Excel that will count cells whose value equals other cells in the same row? Thanks!!!
This is driving me nuts. Sorry if it's a repeat question but I can't find this one in the forum.
I am grading exams. I have two columns, one with the correct answer and one with the answer on the exam. It's a multiple choice test so the answers are just letters.
At the bottom of the second column, I want a count of correct answers. This should be easy...and I thought CountIf would do it, but it seems to need a fixed value to reference, and can't look at other cells.
Is there a function in Excel that will count cells whose value equals other cells in the same row? Thanks!!!