On Sat, 30 Jan 2010 10:52:01 -0800, Mike
wrote:

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,A T$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)


Try this array formula:

=IF(OR(AR6="L",AW6<""),AVERAGE(IF(AT$6:AT$66=0,A T$6:AT$66)),"")

Hope this helps / Lars-Åke