SUMIF not pulling through from source file

[shina67]

Hi All, hope you can help, I have a workbook that pulls information from another workbook.
The workbook is not updating when the source file is closed.
I am using the following formula:
=SUMIF('[Weekly Production 2018 Live Data.xlsx] Daily Summary 2018'!$7:$7,B2,'[Weekly Production 2018 Live Data.xlsx] Daily Summary 2018'!$26:$26)
I don't want the source file to be open how can I do this?

 

[Marcelo Branco]

SUMPRODUCT works with closed workbooks

Try something like this

=SUMPRODUCT(--(CriteriaRange=B2), SumRange)

M.

 

[shina67]

SUMPRODUCT works with closed workbooks

Try something like this

=SUMPRODUCT(--(CriteriaRange=B2), SumRange)

M.

Hi Thank you, I have tried this but I still cant get it to work.

 

[shina67]

Sorry, I was a bit dumb in this formula, i have managed to get it to work, Thank you Marcelo.

 

[Marcelo Branco]

You're welcome.

M.