Hi, I'm having a problem using the SUMIFS function with ranges from closed workbooks. I have read in internet that the #REF ! problem is caused because this function can't work while the referenced workbook is closed and found that it can be done using the SUMPRODUCT function or with SUM and IF together. What I don't know is how to put this formula into either of the options. The issue is more with the "="& syntax into another function. Here's the function that I made(the ranges used are from the workbook referenced):
[TABLE="width: 93"]
<tbody>[TR]
[TD]=SUMIFS(G5:G50,A5:A50,"="&A25,H5:H50,"="&H25)[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[TABLE="width: 93"]
<tbody>[TR]
[TD][/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[TABLE="width: 93"]
<tbody>[TR]
[TD]=SUMIFS(G5:G50,A5:A50,"="&A25,H5:H50,"="&H25)[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[TABLE="width: 93"]
<tbody>[TR]
[TD][/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]