I need help with sorting data

[Big Bill]

I have entered student answers from a 10 question assessment into a spreadsheet and I would like to know how many answers they have correct without correcting each sheet indidually. I have tried to create a SUM(IF) statement, but I'm only getting 1 or 0 for my totals. I have attached what I have so far. Help if you can, please.

 

[SirJB7]

Hi, Big Bill!
Try this array formula in M3:
=SUMA(SI(C3:L3=C$1:L$1;1;0)) -----> in english: =SUM(IF(C3:L3=C$1:L$1,1,0))
Remember that array formulas should be entered with Ctrl-Shift-Enter instead of just Enter.
Copy down as required.
Regards!

 

[3G]

So simple, yet so great SirJB7!

 

[SirJB7]

@3G
Hi!
I frequently quote Albert Einstein: "We are all very ignorant, what happens is that not all ignore the same things". And I firmly believe it.
Thanks for your nice words.
Regards!

 

[krishnaraj]

Please see if the attached sheet works...

 

[SirJB7]

Hi, krishnaraj!
I got these values, 1st column yours, 2nd column mines. Could you please check yours?
3 3
0 6
7 3
5 9
4 7
7 7
7 10
2 2
9 9
2 9
6 7
5 5
5 7
5 10
4 6
9 9
7 6
8 9
4 6
Regards!

EDITED

PS: Giving a quick look at your formulas, you missed fixing row 1 in the formulas, so the formula at C34 should be:
=CONTAR.SI(C3;C$1) -----> in english: =COUNTIF(C3,C$1)
instead of:
=CONTAR.SI(C3;C1) -----> in english: =COUNTIF(C3,C1)
Then it works.

 

[Big Bill]

Thak you SirJB7, that worked perfectly, I always forget to add the $.

 

[SirJB7]

Hi, Big Bill!
Glad you solved it. Thanks for your feedback and welcome back whenever needed or wanted.
Regards!