desperately need help with average
 

This is what i have & works but need to do more
AO6:AO66 = Names from week 1 =IF(AW60,AW6,'Week 1'!S6)
AQ6:AQ66 = week 1 hours & adjusted hours =IF(AO6"",E6+AZ6,"")
AR6:AR66 =L means laidoff=IF(AY60,AY6,"")
AS6:AS66 = Average hours
{=IF(OR(AR6="L",AW6""),AVERAGE(IF(AT$6:AT$66=0,A T$6:AT$66)),"")}
AT6:AT66 = total hours of this week =IF(AR6="L","",AU6)
AU6:AU66 = Total hours of week 1 & this
week=IF(AR6="L",AS6,IF(B6="","",AQ6+SUM(F6:Q6)*1.5 +R6*2+S6*2))
AW6:AW66 = NAMES TO BE ADDED OR CHANGED
AY6:AY66 = L if name is laid off
AZ6:AZ66 = adjust hours if needed

What i need is to:
If AW6:AW66 "" this means names added or changed. Have average put in
AU6:AU66 some how added to what i used above for AU column