SUMIFS - Cell referencing

[jamescooper]

Hello,

I would like to perform the following formula with 1802 being in cell B2, can anyone help please?

Many thanks.

=SUMIFS([1802.xlsx]REVENUE!$V:$V,[1802.xlsx]REVENUE!$K:$K,G6,[1802.xlsx]REVENUE!$E:$E,I4)

 

[Aladin Akyurek]

You are apparently thinking of using INDIRECT, which does not work with closed workbooks.

 

[jamescooper]

You are apparently thinking of using INDIRECT, which does not work with closed workbooks.

The file will be open at the time?

 

[Aladin Akyurek]

The file will be open at the time?

In that case, try:

=SUMIFS(INDIRECT("'["&B2&".xlsx]"&"REVENUE'!$V:$V"),INDIRECT("'["&B2&".xlsx]"&"REVENUE'!$K:$K"),G6,INDIRECT("'["&B2&".xlsx]"&"REVENUE'!$E:$E"),I4)