Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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: 4889) Aug 28, '17 at 10:13 pm
DON'T POST IN ALL CAPS PLEASE!!!
don (rep: 1989) 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