Using offset to select a range
 

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

Using offset to select a range
 

Don't understand the question. Can you post an example of data in each
workbook together with the conditions for the sumif and the result you would
expect in the example of data.

Also this is posted under Excel programming. Do you want the answer in VBA?
--
Regards,

OssieMac


"QuietMan" wrote:

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

Using offset to select a range
 

Thanks, figured it out
--
Helping Is always a good thing


"OssieMac" wrote:

Don't understand the question. Can you post an example of data in each
workbook together with the conditions for the sumif and the result you would
expect in the example of data.

Also this is posted under Excel programming. Do you want the answer in VBA?
--
Regards,

OssieMac


"QuietMan" wrote:

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