Scoring responses by macro

Hi All,

I’m requesting for some help on a macro that will enable me to score my responses.

In the attached:

Tab 1:

“Questions and Answers” has the sample responses collected. The respondent answers are given from Column C onwards
A brief explanation of the 3 logics that am requesting help with are also provided in Column H

Tab 2:

The correct answers per question are given in Column C of this Tab. These are to be used for evaluation of the responses received in Tab 1
All the incorrect responses from Tab 1 by question need to be counted and the counts to be reflected in Column D of this sheet

Look forward to your kind help. I have over 4000 responses on this, and will do such more tests every month.

Please let me know if anything needs further explanation.

Thanks a bunch!


Regards,
Spi