Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conditional format problem | New Users to Excel | |||
Excel 2003 print problem with conditional formatting cell selected | Excel Discussion (Misc queries) | |||
Conditional Formatting problem | Excel Worksheet Functions | |||
conditional sum - number of arguments problem | Excel Worksheet Functions | |||
Conditional summing with large amounts of data | Excel Worksheet Functions |