This is my formula then:
=IFERROR(AVERAGE(Adams:Webb!B4),AVERAGE(Adams:Webb !B4))

But now it returns a #NAME? error





"Eduardo" wrote:

Hi,

=IFERROR(AVERAGE(Sheet2:Sheet3!A2),AVERAGE(Sheet2: Sheet3!A2))
I supposed that you have sheet 2 and 3 and the cell to average is A2

If this helped please click yes. Thank you

"dernspiker" wrote:

I have a spreadsheet with 9 worksheets (named by employee last name).
On the 9th worksheet I want to get the average of cells B4 from each of the
other sheets. Some of these cells may include an N/A.

Can you give me a formula that will overlook the N/A cells?

Thank you!