Why am I unable to autofil this formula? =SUM('[AAL Contractor Statistics.xlsx]Summary Sheet'!$E$28:$E$87)/60

[thisisit]

Apologies for including the formula in the title. I was unable to paste I in here.

Any advice as to why I'm unable to fill the formula? I've tried other formulas and they auto fill, but not this one. Do I perhaps need to do it as a vlookup? If so, any help would be greatly appreciated.

T

 

[thisisit]

I have now worked out the absolute/relative reference. However, I would like the formula to fill horizontally. How would I go about doing this?

 

[DanteAmor]

The formula Sends an error?
DO You have opened the book "AAL Contractor Statistics.xlsx"?
The book has a sheet called "Summary Sheet"?
Where do you put the formula, from VBA?


I put the formula and it works.

 

[thisisit]

https://imgur.com/vXn5GG3

The formula Sends an error?
DO You have opened the book "AAL Contractor Statistics.xlsx"?
The book has a sheet called "Summary Sheet"?
Where do you put the formula, from VBA?


I put the formula and it works.

Apologise, I am for some reason unable to paste code

 

[thisisit]

https://imgur.com/vXn5GG3

 

[DanteAmor]

If you use this, without $:

=SUMA('[AAL Contractor Statistics.xlsx]Summary Sheet'!E28:E87)/60

One cell on the right:
=SUMA('[AAL Contractor Statistics.xlsx]Summary Sheet'!F28:F87)/60

Is that what you need?