How to sum multiple if statements for a scorecard (designate points for correct response)

[bobletcs123]

Hi all,
Trying to put together a scorecard for my sister for her elementary class. They are doing a fun little blind taste test activity... see if you can tell the difference between brands.
I have a manual scorecard, but was trying to see if I could come up with one to automate the scoring.

Want to be able to give a 1 if they match, and 0 if they dont, then be able to sum for each round.
Example: Taste test Frys.
McDonalds= 1
Wendys = 2
Burger King = 3


C is persons guess, U is the answer key. My thought was if they match, give them a 1, then just sum up .... Obviously, didn't work : )

Points cell C5,D5,etc=SUM(IF(C2=$U$2,"1",IF(C3=$U$3,"1",IF(C4=$U$4,"1",0))))

Any suggestions would be greatly appreciated!

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[bobletcs123]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Thanks for the info! Updated my profile.

 

[bobletcs123]

Hi all,
Trying to put together a scorecard for my sister for her elementary class. They are doing a fun little blind taste test activity... see if you can tell the difference between brands.
I have a manual scorecard, but was trying to see if I could come up with one to automate the scoring.

Want to be able to give a 1 if they match, and 0 if they dont, then be able to sum for each round.
Example: Taste test Frys.
McDonalds= 1
Wendys = 2
Burger King = 3


C is persons guess, U is the answer key. My thought was if they match, give them a 1, then just sum up .... Obviously, didn't work : )
View attachment 79831


Points cell C5,D5,etc=SUM(IF(C2=$U$2,"1",IF(C3=$U$3,"1",IF(C4=$U$4,"1",0))))

Any suggestions would be greatly appreciated!

I am on: Microsoft® Excel® for Microsoft 365 MSO (Version 2202 Build 16.0.14931.20764) 64-bit

 

[Fluff]

Thanks for that, how about

=(C2=$U$2)+(C3=$U$3)+(C4=$U$4)

 

[bobletcs123]

Thanks for that, how about

=(C2=$U$2)+(C3=$U$3)+(C4=$U$4)

Worked perfectly!!!
Thank you!

 

[Fluff]

You're welcome & thanks for the feedback.