conditional summing and formatting

[srizki]

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

 

[Andrew Poulsom]

How about?

=IF((C20*D20),SUM(C20:D20),"")

 

[srizki]

Thank You Andrew.

 

[srizki]

How about highlighting if both cells have value.

Thanks

 

[Andrew Poulsom]

You can use the conditional formatting formula:

=($C20*$D20)

 

[srizki]

Thanks again Andrew, I tried this formula before I asked the question, but it did not work, I do not know what I was doing wrong.

Thanks

 

[Andrew Poulsom]

Thanks again Andrew, I tried this formula before I asked the question, but it did not work, I do not know what I was doing wrong.

Thanks

Maybe you forgot the $ signs to fix the column references.

 

[srizki]

I did not forget but did not put the $ sign thinking that it is not necessary, Now I know what was wrong.

Thanks