Help with formula... #DIV/o!

[Mykro]

I could use some help with following formula... My attempts to hide the divide by zero error #DIV/o! have failed...

=IF($B$4<=0,"",AVERAGE(L6:L90))


Thanks...

 

[shg]

=iferror(AVERAGE(L6:L90), "")

 

[Andrew Poulsom]

What is the relationship between B4 and L6:L90? If there isn't a relationship, your test that B4 is less than or equal to zero is irrelevant.

 

[Mykro]

What is the relationship between B4 and L6:L90? If there isn't a relationship, your test that B4 is less than or equal to zero is irrelevant.

It is irrelevant.. Thats now omitted...

 

[Mykro]

=iferror(AVERAGE(L6:L90), "")

I'm using office 2003 for this spread sheet.. IFERROR needs to be ISERROR...

Thanks...

 

[shg]

=if(iserror(AVERAGE(L6:L90)), "", AVERAGE(L6:L90))

 

[Andrew Poulsom]

Try:

=IF(SUM(L6:L90),AVERAGE(L6:L90),"")

 

[Mykro]

Try:

=IF(SUM(L6:L90),AVERAGE(L6:L90),"")

Andrew,

Works like a charm... Thank You..!