Does any on know how to use the offset function to select a range in another
excel file

I'm trying to use this with the sumif function, and want to select the
column location based on target location column A

Thanks
--
Helping Is always a good thing