So I have this problem and I don’t know how to solve it. Here is my function:
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.