How can I count deviations between two rows?
You could employ helper cells located somewhere else on your sheet and
do a sum of those.
Using your setup.
Column A = Student Name:
Columns B - G = Test Answers 1 - 6
Lets use AB as your 1st Helper-Cell:
AB = IF($B3=$B$2,1,0)
AC = IF($C3=$C$2,1,0)
AD = IF($D3=$D$2,1,0)
AE = IF($E3=$E$2,1,0)
AF = IF($F3=$F$2,1,0)
AG = IF($G3=$G$2,1,0)
.....
....
...
..
Copy formula's down as required.
And finally, to total each row of Helper-Cells:
Again, lets assume it Column H.
H3 = SUM($AB3:$AG3)
H4 = SUM($AB4:$AG4)
.....
....
...
..
Copy formula's down as required.
HTH
Mick.
|