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" <(E-Mail Removed)> wrote in message
news:1AD42852-6F72-47C2-8609-(E-Mail Removed)...
>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 <mygrps...@discussions.microsoft.com>
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