Ok, that means the cells aren't empty. They contain 0s.

I see that Jim gave you a suggestion that will account for that but, is 0 an
otherwise valid entry?

5
0
3
2
0
0
0
0

Is the first 0 a valid entry?

--
Biff
Microsoft Excel MVP


"Ed O'Brien" wrote in message
...
The function is dividing by 31 regardless of how many cells have data. If
only 2 cells have data, say 30 in total, Average shows 0.97 while the real
average is 15.0.


"T. Valko" wrote in message
...
how I get the "AVERAGE" function to
ignore the empty cells.

Average ignores empty cells.

You haven't said how these empty cells are affecting your average?

Could it be that your feeder formulas return 0 but you have the cells set
to not display 0 values?

--
Biff
Microsoft Excel MVP


"Ed O'Brien" wrote in message
...
Excel 2007.

I have 3 columns of data where the daily amount over the month is posted
by a formula relating to another sheet in the same book. Below each
column I want to display the daily Average of the data in that column.

When the data was typed into the columns (cells) the "AVERAGE" function
worked okay. However, now that the data is called up via a formula, the
"AVERAGE" calculates across all 31 cells in the column, including those
with no data yet posted.

Can someone tell me how I get the "AVERAGE" function to ignore the empty
cells.

TIA for any help.

Ed