"Average" Function in Excel

Giganews Newsgroups
Subject: "Average" Function in Excel
Posted by:  ClintonOrlando
Date: Sat, 3 Jun 2006

Hi there.
I'm having difficulty getting a cell to accurately show an average of
specific cells with values.  it is counting all of the zeros in the column
and I can't figure out how to make the cell not show zeros without going
through and deleting each one (hundreds!).  (The cells I'm averaging have
formulas in them where they're copies from other cells and when those
original cells are empty, these cells then show a "0.00")