Hi all
First time poster and very much an excel novice.
I know how to use a few basic formulas but more complicated functions elude me so far so I thought I would ask for help with something that feels a little more ambitious before I get in over my head.
I'm working on making scoring sheet for a quiz, where the answers are submitted online via a survey website from which i can then export the answers as an excel document. My next task is to find a way to easily and quickly mark the text anwers (up to 100 submissions of 40 questions) and I was hoping to find a way to automate this in excel.
What i envisage in my head is a sheet where i can paste in the answers generated from the survey website and which would then be recognised as right or wrong based on some kind of conditional formatting, which i know how to do.
My question is, is there a way to then use that conditional formatting to tally up the amount of correct or acceptable answers a player has and give me a numerical indication of their score? So if player A has 5 questions which fulfill the conditions to set off the formatting then somehow their score would be totalled up as 5. Ive attached a sample workbook which I hope shows what i want to achieve.
Could anybody point me in the right direction to achieve this?
Thanks everyone.
Charlie Gibbons
Bookmarks