You need to edit the link, if it for instance looks like

=Sheet2!$A$1


then change it to


=IF(Sheet2!$A$1="","",Sheet2!$A$1)


Of course if there can be no zeros in your average then you can change the
average formula


=AVERAGE(IF(A2:A100<0,A2:A100))

or if there can be no zeros nor negative values

=AVERAGE(IF(A2:A1000,A2:A100))


both formulas entered with ctrl + shift & enter


--


Regards,


Peo Sjoblom





--


Regards,


Peo Sjoblom


"upsidedown_pw" wrote in message
...
I have a parent spreadsheet in tab 1 and on seperate tabs I have chunks of
the information through paste special and paste link. When the parent
cell
is empty, the paste link command is putting a zero in instead of leaving
it
blank. This is messing up my averages. I have tried changing the
category
in format cells but this has no effect.

I anyone knows the answer it'd be much appreciated :)