How to add continuous 5 or 10 rows by giving number of rows to ad

[mygrps100]

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

 

[Bob Phillips]

=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)

 

[nkc]

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

 

[vezerid]

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