SUMPRODUCT RC1 Style

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top