# Excel help -- averaging figures from different sheets

**URL:** <https://boards.straightdope.com/t/excel-help-averaging-figures-from-different-sheets/984921>\
**Category:** Factual Questions\
**Created:** [June 2, 2023, 4:05pm UTC](https://boards.straightdope.com/t/excel-help-averaging-figures-from-different-sheets/984921 "2023-06-02T16:05:47Z")\
**Posts on this page:** 3\
**Page:** 2

<div class="post-metadata">

**Author:** ![Riemann](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/riemann/32/3133_2.png) [@Riemann](https://boards.straightdope.com/u/Riemann)\
**Post date:** [June 2, 2023, 5:16pm UTC](https://boards.straightdope.com/t/excel-help-averaging-figures-from-different-sheets/984921/21 "2023-06-02T17:16:05Z")

</div>

> [@Akaj](#):
>
> And both May and August are spelled correctly in the sheet names.

Start a new sheet, and just test the formula with the default sheet names to be completely sure.

---

<div class="post-metadata">

**Author:** ![Borborygmi](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/borborygmi/32/217_2.png) [@Borborygmi](https://boards.straightdope.com/u/Borborygmi)\
**Post date:** [June 2, 2023, 6:44pm UTC](https://boards.straightdope.com/t/excel-help-averaging-figures-from-different-sheets/984921/22 "2023-06-02T18:44:30Z")

</div>

> [@Akaj](#):
>
> Could the problem be the XL I’m using? It’s in Drive, and the spreadsheet name ends in .XLSX

I think this is it, based on the link below. My take is that it’s okay if the file is on Google Drive but not if you’re using Google Sheets to edit. I don’t have the means to test this out, though. Good luck!

[https://support.google.com/docs/thread/131535458/error-unknown-range-name?hl=en](https://support.google.com/docs/thread/131535458/error-unknown-range-name?hl=en)

---

<div class="post-metadata">

**Author:** ![Akaj](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/akaj/32/145_2.png) [@Akaj](https://boards.straightdope.com/u/Akaj)\
**Post date:** [June 2, 2023, 6:52pm UTC](https://boards.straightdope.com/t/excel-help-averaging-figures-from-different-sheets/984921/23 "2023-06-02T18:52:23Z")

</div>

> [@Borborygmi](#):
>
> My take is that it’s okay if the file is on Google Drive but not if you’re using Google Sheets to edit.

Folks, we have a winner!

As soon as I downloaded it to my desktop, it worked.

Thanks, everyone!

[Previous page](https://boards.straightdope.com/t/excel-help-averaging-figures-from-different-sheets/984921.md?page=1)