srizki
Well-known Member
- Joined
- Jan 14, 2003
- Messages
- 1,860
- Office Version
- 365
- Platform
- Windows
Columns C and D occupies labor hours. Some technicians hours are on both columns. (Names of tech are in Column B), I want to add the hours in another columns only if the tech's hours are in both of the columns. So for example Daniel B20, hours 142 are in C20 and 35 in D20, I want to highlight those hours as well as sum of those, and I want blank if the condition did not meet. something like,
=IF(AND(C20<>"",IF(D20<>"",SUM(C20:D20),""))
OR
=IF(C20,C20+D20,"") - if D20 hosts any value it adds up. and I do not want is.
Thanks
=IF(AND(C20<>"",IF(D20<>"",SUM(C20:D20),""))
OR
=IF(C20,C20+D20,"") - if D20 hosts any value it adds up. and I do not want is.
Thanks