I have a data set where i want to add 5 cells in a column somewhere then
subsequent 10 cells (in same column) then say 8 cells and so forth. How can
this be done by just giving the number of contnuous cells to be added). Like
can i say add next 5 then next 10 etc

=SUM(A1:INDEX(A:A),B1)

put the number in B1

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"mygrps100" wrote in message
...
I have a data set where i want to add 5 cells in a column somewhere then
subsequent 10 cells (in same column) then say 8 cells and so forth. How
can
this be done by just giving the number of contnuous cells to be added).
Like
can i say add next 5 then next 10 etc

U have to use Lookup and offset method to resolve this problem

"mygrps100" wrote:

I have a data set where i want to add 5 cells in a column somewhere then
subsequent 10 cells (in same column) then say 8 cells and so forth. How can
this be done by just giving the number of contnuous cells to be added). Like
can i say add next 5 then next 10 etc

If I have understood you correctly then the following layout can solve
your problem:

Assume numbers are in A2:Ax. Say your summation interval lengths are
in K2:K9 (e.g. the numbers 5, 10, 8, etc). Start by putting a 0 above
these numbers, in this case in K1.

Now, next to the lengths, in L2, enter the following formula:

=SUM(OFFSET($A$2,SUM($K$1:K1),0,K2,))

Copy down as far as necessary.

HTH
Kostis Vezerides

On Jun 24, 3:14 pm, mygrps100
wrote:
I have a data set where i want to add 5 cells in a column somewhere then
subsequent 10 cells (in same column) then say 8 cells and so forth. How can
this be done by just giving the number of contnuous cells to be added). Like
can i say add next 5 then next 10 etc