Conditional summing problem
 

A1:J1 contains 10 maximum test scores A2:J2 contains X's if the test is
supposed to be counted A3:J3, A4:J4, ... contain test scores of pupils (a
blank if the pupil did not take the test)

I now want the cells K3, K4, ... to show the maximum total test score of
the X marked tests the pupil in question took, so for example K9 should be
the sum of the A1:J1 if the cell in A2:J2 has an X and A9:J9 is not blank.

Conditional summing problem
 

=SUMPRODUCT((A$1:J$1),--((A$2:J$2)="X"),--((A3:J3)<""))
--
David Biddulph

"Fons" wrote in message
.. .
A1:J1 contains 10 maximum test scores A2:J2 contains X's if the test is
supposed to be counted A3:J3, A4:J4, ... contain test scores of pupils (a
blank if the pupil did not take the test)

I now want the cells K3, K4, ... to show the maximum total test score of
the X marked tests the pupil in question took, so for example K9 should be
the sum of the A1:J1 if the cell in A2:J2 has an X and A9:J9 is not blank.