M
Mike
In cell C4 im calculating average hours for D5
65 of all employees
In cells Z5:Z65 If L is entered means laid off
In cells AB5:AB65 IS AVERAGE OF ALL EMPOLYEES HOURS in cells D565 if L is
entered in Z Column
In cells D565 IS all employees hours
FORMULA FOR C4 IS
{=AVERAGE(IF(ISNUMBER(D565),IF(D565>0,D565,0)))}
Formula for cells AB5:AB65 IS
=IF(Z5="L",R4,"")
Formula for D565 IS
=IF(Z5>0,0,IF(B5="","",AA5+SUM(E5:J5)*1.5+K5*2))
I want to average all employees hours except if L is entered in Z Column so
say 65 employee hours if L is entered i want to calculate THE OTHER 64
EMPLOYEES HOURS FOR THIS EMPLOYEE & Yes there will be zero values only in
column D565
65 of all employeesIn cells Z5:Z65 If L is entered means laid off
In cells AB5:AB65 IS AVERAGE OF ALL EMPOLYEES HOURS in cells D5
65 if L isentered in Z Column
In cells D5
65 IS all employees hoursFORMULA FOR C4 IS
{=AVERAGE(IF(ISNUMBER(D5
65),IF(D565>0,D565,0)))}Formula for cells AB5:AB65 IS
=IF(Z5="L",R4,"")
Formula for D5
65 IS=IF(Z5>0,0,IF(B5="","",AA5+SUM(E5:J5)*1.5+K5*2))
I want to average all employees hours except if L is entered in Z Column so
say 65 employee hours if L is entered i want to calculate THE OTHER 64
EMPLOYEES HOURS FOR THIS EMPLOYEE & Yes there will be zero values only in
column D5
65