Another DIV/0 Error

[Tony P.]

Hello,

I have a list of data that I need to average. In order to remove a div/0
error, I entered this formula = IF((B4<>0),AVERAGE(B:B)). This formula works
as long as there is a number in column B other than 0. If any number in
column B is blank or 0, the result is FALSE. Is there a way to remove the
FALSE statement?

 

[Sheeloo]

= IF((B4<>0),AVERAGE(B:B),"") if you want blank

and

= IF((B4<>0),AVERAGE(B:B),0) if you want zero

 

[Dave Peterson]

I'd use a formula like:
=if(count(b:b)=0,"no numbers",average(b:b))