SUMPRODUCT Help

[TheCobbler]

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

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

Thank you!

 

[TheCobbler]

Switched it to this which does the job!

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