Thread: Marksheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Salza Salza is offline
external usenet poster
 
Posts: 4
Default Marksheet

Having a problem to get a correct formula for overall passing.

Marks are keyed into the following cells for all the 26 subjects.

Cell F8 = Subject 1
Cell H8-R8 = Subjects 2-7
Cell T8-BE8 = Subject 8-26

To pass the overall exam - a student must pass FIVE subjects (Subject
1, any TWO from Subjects 2-7, and any TWO from Subjects 8-26).

Passing mark for each subject is 36.

Can someone help me with the formula? Thank you.