# formula for Sum Total of two different workbooks in excel

#### Kajal

##### New Member
We have two different workbooks (Master & Slave) both the workbooks have one unique column i.e ID. Slave workbook has duplicates ID along with Amount figure. We want to get the sum total of those duplicates ID's amount and single entry amount should also be reflected on our Master workbook amount column.
eg

Slave Workbook

ID Amount
766 800
566 900
766 1000
675 200
566 100

Master Workbook

ID Amount
766
566
675

### Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
@Kajal

Hi

Welcome to Forum, Glad you are here

What you want to achieve your

as per my understanding you want to sum the amount against IDS which is mention Master Book from Slave Workbook where you enter the data daily, if is it correct

suppose your data in the Column A & B of Slave Workbook and Single ID IN Master Workbook in the A

1. Open Both Workbooks

2. In Master Workbook write the below Formula in Column B1 as

3. =SUMIFS([Slave Workbook]Sheet1!\$B\$1:\$B\$5,[Slave Workbook]Sheet1!\$A\$1:\$A\$5,\$A1)

Thanks

SP

Thanks SP for helping, but i am facing problem, as in when i enter the formula it shows "That name is not valid" and highlights Slave as i have shown in green color font.

=SUMIFS(
[Slave Workbook]Sheet1!\$B\$1:\$B\$5,[Slave Workbook]Sheet1!\$A\$1:\$A\$5,\$A1)

@Kajal

Hi

as per your formula in the first array you are not mention any space in the Workbook Name and in the second array you mention the workbook name with space

=SUMIFS([SlaveWorkbook]Sheet1!\$B\$1:\$B\$5,[Slave Workbook]Sheet1!\$A\$1:\$A\$5,\$A1)

1. Open Both Workbooks

2. write the formula in B1 of the Master Workbook as

3. =SUMIFS(

4. Select the range of the Slave Workbook of Column B for Example amount is stored in the Column B if any headings in the Column B1 then select from B2:B10 (range adjust as you like)

5. ,

6. Select the Range of the Slave Workbook of Column A range from A2:A10,\$a1

7. Finally Bracket Close ) and enter

Thanks

Patnaik

What are the real names of the two workbooks?

Replies
6
Views
201
Replies
6
Views
476
Replies
0
Views
570
Replies
17
Views
942
Replies
13
Views
1K

1,207,094
Messages
6,076,549
Members
446,212
Latest member
KJAYPAL200

### 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