=AVERAGE(Sheet1!A1,Sheet2!A1,Sheet3!A1) up to 30 cells in this manner
even if there is no data for say 4 out of 14 points, then the AVERAGE
function will still average the arithmetic mean out the 10 with data.


"Darren" wrote:

Hello - I am trying to get the average of 14 cells on 14 different sheets,
i.e. cells C14 on worksheets 1-14. The problem I am running into is that
some of these cells may contain no data and so I am getting the #DIV/0!
error. Help...