Excel - Workbook to Workbook Calculation

Hey, quick question here.

In one workbook i have a range of values, for example A1:A20 of data entries where I need to calculate the average of those numbers and enter that average value in another workbook. I was wondering if its possible to complete this calculation across workbooks?

Sure it is.

Something like this:

=AVERAGE([symbols.xlsx]Sheet1!$A$1:$A$20)

where your source WorkBook is named "symbols.xlsx" your range is in Sheet "Sheet1"