average with N/A
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!
|