N
NPell
Hello,
I have a formula that is to sum a range, based on the value of a cell,
and i cant get it to work.
I have in the Columns:
A: Date
B: Number of Months between Date and Jan 2003.
C: Column Reference, based on B.
D: ** where im trying to do the formula.
E, F,G and H contain other information.
The columns are then, after the above, laid out in.
I: Jan 03 (as header), with a value.
J: Feb 03 (as header), with a value.
K: Mar 03 (as header), with a value.
Etc.
The from date varies on each row.
So, from working out the column number, i switched to RC1 style.
Example, my first date is to Mar 06, Formula says its 50 - (i checked,
its correct).
So, my thinking is i can sum from Column I (9) to Column 50.
Using something like:
=sumproduct--(INDIRECT("(RC[4]:RC["&RC[-1]&"])"))
This is because SUM didnt work...
But, this still does not work.
Any ideas? Or even another way to do it?
Thanks in advance.
I have a formula that is to sum a range, based on the value of a cell,
and i cant get it to work.
I have in the Columns:
A: Date
B: Number of Months between Date and Jan 2003.
C: Column Reference, based on B.
D: ** where im trying to do the formula.
E, F,G and H contain other information.
The columns are then, after the above, laid out in.
I: Jan 03 (as header), with a value.
J: Feb 03 (as header), with a value.
K: Mar 03 (as header), with a value.
Etc.
The from date varies on each row.
So, from working out the column number, i switched to RC1 style.
Example, my first date is to Mar 06, Formula says its 50 - (i checked,
its correct).
So, my thinking is i can sum from Column I (9) to Column 50.
Using something like:
=sumproduct--(INDIRECT("(RC[4]:RC["&RC[-1]&"])"))
This is because SUM didnt work...
But, this still does not work.
Any ideas? Or even another way to do it?
Thanks in advance.