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 ?
Sorry for my crappy english, it's not my first language.
Thank you
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!