• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to get average across sheets with #N/A in data?

Goldcar400

New Member
Hello

How to get the average() function to work across sheets with #N/A in data? The result is in sheet cc3 and data are in sheets aa1 and bb2. The data is in non contiguous cells, one cell ranges.

See attached file.

Regards
Tony
 

Attachments

Top