One way:

=IF(COUNTIF(A1:J1,0)=10,AVERAGE(A2:J2),5)

In article ,
Linda wrote:

I need help for the following situation:
If A1:J1=0, Average A2:J2(true), 5(false)

I typed in the fomula: IF(A1:J1=0,AVERAGE(A2:J2),5)

But it did not work. I kept gettng #signs. Deeply appreciated if somebody
help.

Thanks,
Linda