Excel Excel sum within range help

Mar 10, 2008
Reaction score
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?


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