Clarification:
The value in cell B1 actually
indicates the Row Number to add through.

To use it to indicate how many cells to add
use this formula:
A1: =SUM(A2:INDEX(A:A,ROW(A2)+B1-1))

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Ron Coderre" wrote in message
...
Try something like this:

B1: (number of cells to add.....eg 10)
A1: =SUM(A2:INDEX(A:A,B1))

In that example, the formula in A1 sums cells A2:A10

Is that something you can work with?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"porbeagle" wrote in message
...
I have a huge number of lists that I am calculating. I have a vertical
list
of numbers
each vertical cell represents a week. I am trying to add up a varing
number
of week forward to madel stock controls. Currently I am adding up each
individual cell for the number of week that i need (ie 4 weeks is
=sum(a2+a3+a4+a5). This is very clumsy and time consuming. Is there a way
to
write a formula that adds up a specified number of cells forward. i.e add
ten
cells down the list and return total?