I think this does what you want...

=AND(F8<"",COUNTA(H8:R8)1,COUNTA(T8:BE8)1)

but I do note that your H8:R8 and T8:BE8 ranges span more columns that there
are subject to fill them... note sure how, or if, that affects the formula.

--
Rick (MVP - Excel)



"Salza" wrote in message
...
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.