Use string in sum function

Hi,

I used the string 'G:\Crush\Daily plant reports\2019\[05-2019.xls]C vol'!$F$35:OFFSET('G:\Crush\Daily plant reports\2019\[05-2019.xls]C vol'!$F$35,0,0) in sum function and I get #REF error. Any help on this?

Please update your profile to at least give members an idea of where you are located.
It does not have to be city specific, but the country would eventually be useful in some cases.
Thank you

Originally Posted by Pepe Le Mokko

Please update your profile to at least give members an idea of where you are located.
It does not have to be city specific, but the country would eventually be useful in some cases.
Thank you

Thanks, I have updated some of the data.