# SUMPRODUCT Help

#### TheCobbler

##### New Member
Hi, Looking to update this formula so it works across closed workbooks. Do I need to change to SUMPRODUCT? If so any help welcome!

Excel Formula:
``=SUMIF('https:****/[Orders.xlsx]Master'!\$B:\$B, D14, 'https:****/[Orders.xlsx]Master'!\$C:\$C)``

Thank you!

Last edited by a moderator:

### Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
Switched it to this which does the job!

Excel Formula:
``=SUMPRODUCT(('https://****.xlsx]E***'!\$B\$1:\$B\$27=D14)*'https://****.xlsx]****'!\$C\$1:\$C\$27)``

Last edited by a moderator:

Replies
2
Views
99
Replies
4
Views
122
Replies
7
Views
1K
Replies
6
Views
209
Replies
2
Views
216

1,203,506
Messages
6,055,806
Members
444,825
Latest member
aggerdanny

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