Help with SUMIF formula to link to another workbook

[JrExcelTor]

Hi All,

I have a project I am working on where I was recently asked to separate the data capture sheet of a workbook (let's call this workbook 1) and capture it in another workbook (workbook 2). This was the formula I was using to capture the data within workbook 1:

=SUMIF(INDIRECT("'"&C2&"'!$A:$A"),D2&F2&B2,INDIRECT("'"&C2&"'!$"&A2&":$"&A2))

The mapping for workbook 2 is: C:\Users\BLG0717\Desktop\2016 Planning Tool

I have had no luck trying to recapture this data in a separate workbook. Does anyone have any suggestions?

Thanks in advance

 

[Cosmic Wizard]

Hi All,

I have a project I am working on where I was recently asked to separate the data capture sheet of a workbook (let's call this workbook 1) and capture it in another workbook (workbook 2). This was the formula I was using to capture the data within workbook 1:

=SUMIF(INDIRECT("'"&C2&"'!$A:$A"),D2&F2&B2,INDIRECT("'"&C2&"'!$"&A2&":$"&A2))

The mapping for workbook 2 is: C:\Users\BLG0717\Desktop\2016 Planning Tool

I have had no luck trying to recapture this data in a separate workbook. Does anyone have any suggestions?

Thanks in advance

Sorry don't understand what you are trying to do.

Do you mean that you want the data to move to another work sheet?

Or do you want to sum or count up the data?