Enter this formula in G4:
=8.5*SUMPRODUCT(--(B4:F4="F"),--(B2:F2<"F"))
+5*SUMPRODUCT(--(B4:F4="F"),--(B2:F2="F"))
A B C D E F G
1 Name Week 1
2 M T W T F
3
4 EMPLOYEE F F H F formula

Regards,
Stefi