Instead of something like:
=Sheet1!A1
use:
=if(Sheet1!A1="","",Sheet1!A1)
--
Gary''s Student - gsnu200908


"outrigger" wrote:

I brought cell information from worksheet B into worksheet A, by typing = in
a cell and then clicking on cell in worksheet B and hitting enter. Data in
that cell is empty. So excell placed a "0" in the final cell. When I average
the column it of course adds the zero's. I don't want it to do that, only
the numbers gtreater that '0". How do I get this accomplished?