Hi all,
I'm having a problem with a calculation.
I wish to sum a group of values who's begin point and end point depend on other criterion.
Here is an example of the ranges I'm looking at (actually based on the amortization of a loan):
n interest
0 0
0 0
1 1000
2 999
3 998
4 997
5 996
6 995
7 994
8 993
9 992
10 991
11 990
12 989
13 988
14 987
15 986
0 0
0 0
Now, I have a cell finding that I need to begin summing the interest column when n=a. What I want a new cell to do is actually sum the interest column from n=a to n=a+12. In this case, say I want to begin summing at n=2. I then want to sum the interest column from n=2 to n=14.
The values in the n and interest columns are derived from formulas based on other data.
Is there a way to do this?
I'm having a problem with a calculation.
I wish to sum a group of values who's begin point and end point depend on other criterion.
Here is an example of the ranges I'm looking at (actually based on the amortization of a loan):
n interest
0 0
0 0
1 1000
2 999
3 998
4 997
5 996
6 995
7 994
8 993
9 992
10 991
11 990
12 989
13 988
14 987
15 986
0 0
0 0
Now, I have a cell finding that I need to begin summing the interest column when n=a. What I want a new cell to do is actually sum the interest column from n=a to n=a+12. In this case, say I want to begin summing at n=2. I then want to sum the interest column from n=2 to n=14.
The values in the n and interest columns are derived from formulas based on other data.
Is there a way to do this?