Y
yk__
Hi,
I have the following functions working perfectly well:
=SUMSQ(OFFSET($G$2,$T$3-ROW($G$2),0,Number_of_Periods,1))
I also have the following working well:
=SUMSQ(OFFSET($H$2,$T$3-ROW($H$2),0,Number_of_Periods,1))
But the following function returns the #NUM! error
=SUMXMY2(OFFSET($G$2,$T$3-ROW($G$2),0,Number_of_Periods,1),OFFSET($H$2,$T$3-ROW($H$2),0,Number_of_Periods,1))
I tried other functions that operate on two dynamic range parameters and
they also don't work.
I tried in Excel 2003 and Excel 2007.
What am I doing wrong?
Thanks
I have the following functions working perfectly well:
=SUMSQ(OFFSET($G$2,$T$3-ROW($G$2),0,Number_of_Periods,1))
I also have the following working well:
=SUMSQ(OFFSET($H$2,$T$3-ROW($H$2),0,Number_of_Periods,1))
But the following function returns the #NUM! error
=SUMXMY2(OFFSET($G$2,$T$3-ROW($G$2),0,Number_of_Periods,1),OFFSET($H$2,$T$3-ROW($H$2),0,Number_of_Periods,1))
I tried other functions that operate on two dynamic range parameters and
they also don't work.
I tried in Excel 2003 and Excel 2007.
What am I doing wrong?
Thanks