This is what I have
In AA5:AA65 IF L is entered = Laidoff
In D5:D65 = AVERAGE of each cells in E5:E65 Total hours worked if L is
entered in AA5:AA65
In B5:B65 = Names if entered
In cells F5:F65 to L5:L65 = Hours entered if worked

This is the formula im using IN E5:E65 = Total hours
=IF(B6="","",SUM(AB5+F5*1.5+G5*1.5+H5*1.5+I5*1.5+J 5*1.5+K5*1.8+L5*2))

This is what I want: If there is a value in D5:D65 I want to use this value
& have this value in E5:E65 I don,t want to SUM & If there is no value in
D5:D65 I want to SUM AB,F,G,H,I,J,K,L5:65 I HOPE THIS MAKES SENCE & POSSIBLE