Hi,

Excel will ignore blank cells in an average formula even across multiple
sheets, try this

=AVERAGE(Sheet1:Sheet3!A1)

Mike

"excel calc" wrote:

I am calculating the average of numerical values from the same cell of many
worksheets. some cells don't have available value. the calc returns error
because it substitutes the empty cell with the value 0. How do you write a
formulae that ignore the empty cell and does not include it in the calc?