not understand

[kaja48380]

Column A Column B C
D
E
Question1 Question2
Question 3
Question 25


Correct Answer: A D
A
C


John Bratty C
D A
B
Willy Wonka D
A D
C
Jenny Penny A
B A
C


=SUMPRODUCT(--(B2:Z2=$B$1:$Z$1))

 

[Jim Cone]

Helpful newsgroup posting advice here...
http://www.cpearson.com/excel/newposte.htm
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)




<[email protected]>
wrote in message
Column A Column B C
D
E
Question1 Question2
Question 3
Question 25


Correct Answer: A D
A
C


John Bratty C
D A
B
Willy Wonka D
A D
C
Jenny Penny A
B A
C


=SUMPRODUCT(--(B2:Z2=$B$1:$Z$1))