Trying to retrieve data from another file using path location and reference cells in a formula

Anonymous
2022-06-08T08:48:48+00:00

I'm trying to retrieve data from other files stored on my device and I'm having difficulty finding the correct functions or syntax to achieve this. I have the file path and sheet name ready in a cell, I have the reference data location in that file, and I'm trying to input these two into a cell to calculate the average of those reference cells in the other file. Attached is a screenshot.

Any help would be appreciated, thank you in advance.

Microsoft 365 and Office | Excel | For business | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
{count} votes

0 additional answers

Sort by: Most helpful