Calculate the total hours a teacher takes in a week

0

If B13=DKS, CHECK IF ANY CELL FROM B3:F3, B5:F5, B7:F7 (FOR EXAMPLE B3,E3,C5,E5,D7,E7,F7=DKS) THEN CHECK IN B4,E4,C6,E6,D8,E8,F8 FOR L1+DT1 OR L1 OR DT1 OR L1+DT1.5, L1.5 ETC. IF ANY CELLS MATCHES ADD ALL THE NUMBERS. HERE THE 1+1 IN L1+DT1, 1 IN L1, 1+1.5 IN L1+DT1.5. CAN I GET A FORMULA FOR THIS.

Answer
Discuss

Discussion

The short answer to your question is "No". I suggest you post a copy of your workbook ("sanitise" it for publication) and I will try to make some suggestions how you might realise your idea.
Variatus (rep: 813) Aug 28, '17 at 10:13 pm
DON'T POST IN ALL CAPS PLEASE!!!
don (rep: 1247) Aug 29, '17 at 8:47 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login