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!