# Help with SUMIF formula to link to another workbook

#### JrExcelTor

##### New Member
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?

Last edited:

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.
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?

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?

Replies
6
Views
406
Replies
2
Views
209
Replies
9
Views
131
Replies
3
Views
597
Replies
5
Views
182

1,202,964
Messages
6,052,829
Members
444,602
Latest member
Cookaa

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back