Conditional summing problem

F

Fons

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top