I have A workbook that contains 26 worksheets. Sheet 26 is a summary page
that gives a running total of of the information entered in the previous 25
pages. I need to be able to do an average of the contents of one cell but I
cant have the average include the null cells or zero value cells from the
worksheets that have yet to be populated. I have been using this Aray
formula:
{=AVERAGE(IF('2-20:8-14'!B28<0,'2-20:8-14'!B28))}

but I keep getting #ref errors. What am I doing wrong or do you have a
better way of doing this function.

Thanks,

Erik

Thanks