M
Mike
This is what i have & works but need to do more
AO6:AO66 = Names from week 1 =IF(AW6>0,AW6,'Week 1'!S6)
AQ6:AQ66 = week 1 hours & adjusted hours =IF(AO6>"",E6+AZ6,"")
AR6:AR66 =L means laidoff=IF(AY6>0,AY6,"")
AS6:AS66 = Average hours
{=IF(OR(AR6="L",AW6>""),AVERAGE(IF(AT$6:AT$66>=0,AT$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
AO6:AO66 = Names from week 1 =IF(AW6>0,AW6,'Week 1'!S6)
AQ6:AQ66 = week 1 hours & adjusted hours =IF(AO6>"",E6+AZ6,"")
AR6:AR66 =L means laidoff=IF(AY6>0,AY6,"")
AS6:AS66 = Average hours
{=IF(OR(AR6="L",AW6>""),AVERAGE(IF(AT$6:AT$66>=0,AT$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