Hi all,
I am trying to get the value that is one column to the right of this formula, but am having problems finding the solution. I have tried Offset(Formula,0,1,1,1) but excel doesn't like it. Have simillarly tried putting the offset inside the Sumifs as well as inside the Index, but am not having any luck getting it to work.
Anybody know what I am doing wrong? Thanks so much.
=SUMIFS(INDEX('[November financials.xlsx]300 - STAT-A'!$B:$AG,0,MATCH("MTD",'[November financials.xlsx]300 - STAT-A'!$B$6:$AG$6,0)),'[November financials.xlsx]300 - STAT-A'!$A:$A,"*T&E*")
I am trying to get the value that is one column to the right of this formula, but am having problems finding the solution. I have tried Offset(Formula,0,1,1,1) but excel doesn't like it. Have simillarly tried putting the offset inside the Sumifs as well as inside the Index, but am not having any luck getting it to work.
Anybody know what I am doing wrong? Thanks so much.
=SUMIFS(INDEX('[November financials.xlsx]300 - STAT-A'!$B:$AG,0,MATCH("MTD",'[November financials.xlsx]300 - STAT-A'!$B$6:$AG$6,0)),'[November financials.xlsx]300 - STAT-A'!$A:$A,"*T&E*")