Can you help me solve this problem with Excel?

Emilie D-b June 14, 2013
Pinterest Stumbleupon Whatsapp

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

Ads by Google

  1. Tina Sieber
    June 16, 2013 at 9:15 am

    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!