Readers like you help support MUO. When you make a purchase using links on our site, we may earn an affiliate commission. Read More.

Hi,

So I have this problem and I don't know how to solve it. Here is my function:

 =(SUM.XMY2(INDIRECT("B37:B"&(ROW(B122)-E2));INDIRECT("B"&(ROW(B37)+E2)&":B122")))

Excel write #REF

Both of my matrixes: INDIRECT("B37:B"&(ROW(B122)-E2)) and INDIRECT("B"&(ROW(B37)+E2)&":B122") work perfectly alone in a sum function. I supposed that the problem is the way I integrated it in the sum.xmy2 function. Could you help me solve it ?

MAKEUSEOF VIDEO OF THE DAY
SCROLL TO CONTINUE WITH CONTENT

Sorry for my crappy english, it's not my first language.

Thank you

Tina Sieber
2013-06-16 09:15:15
Emilie,You might want to take this question to an Excel support forum, such as the Excel Forum or the Microsoft Community Support Forums .Do let us know if you discover a solution!