This is what i have & works well
{=IF(AR6="L",AVERAGE(IF(AT$6:AT$66=0,AT$6:AT$66)) ,"")}
Now what im trying to do is add AW6 IF name is entered
I tried these but not working
{=IF(AR6="L",IF(AW6"",AVERAGE(IF(AT$6:AT$66=0,AT $6:AT$66)),"")}
{=IF(AR6="L",OR(IF(AW6"",AVERAGE(IF(AT$6:AT$66=0 ,AT$6:AT$66)),"")}
I get a Name or False error( CAN SOMEONE PLEASE HELP)