In need of a formula. Then maybe i can turn write it into a vba code.

[zone709]

Hi I need a formula for my sheet any help?

If in Column "C" it says Engineer in any number line to add all hours in total SUM from column E,I,M,Q,U. ?

This shouldn't be hard, but I don't know how to do it

 

[zone709]

I just got it to work, but if I put formula in Column lets say B on the bottome. I had it in Column C and when there it would give me 0.

 

[Scott Huish]

Something has to be different then because as you can see I put my formula in C1 and it worked just fine.

 

[zone709]

Something has to be different then because as you can see I put my formula in C1 and it worked just fine.

yeah weird ill look tomm again thanks