Maybe try something like

=IF(COUNT(A1:A10)=0,"",AVERAGE(A1:A10))

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"teacher1" wrote in message
...
I am a very basic XL user, but I work with spread sheets using the simple
AVG
formula. Is there any way to by pass the "0" in DIV/0? in other words, I
am
using 4 columns of numbers that were each averaged. There is another
column
with the average of the 4 separate columns, but I get the "DIV/0" unless
all
4 of the other colums have a base larger than "0". In other words do I
have
to wait until all 4 coulms are completed before I can determine the on
going
average, or is there a formula or way to get the averages of the columns
that
do not have a zero base and not have to wait until all 4 colums have a
base
larger than zero?