1.

=SUM(INDEX(1:1,,1):INDEX(1:1,,A7))

or

=SUM(OFFSET($A$1,,,,A7))

2.

=SUM(INDEX(1:1,,A7+1):INDEX(1:1,,A7+A8))

or

=SUM(OFFSET($A$1,,A7,,A8))


I prefer the INDEX since it is non volatile

--
Regards,

Peo Sjoblom

(No private emails please)


"Scot B" <news@chicagomedia.com> wrote in message
news:3Z6dnaXV4K6tlwTenZ2dnUVZ_sadnZ2d@comcast.com...
> Greetings, Experts,
>
> I'm sorry for not following the earlier advice, i just don't get it.
> perhaps i'm not explaining well.
>
> We're trying to define the formula that will look at a row of data and sum
> a specific number of cells into a new cell (called the new cell A2).
> then, cell B2 picks up summing the row for a specified number of cells and
> puts that sum into B2.
>
> Here's the sample data, in a row. Row 1: 10,35,50,7,25,48
>
> Cell A7 has the value "3", which means that we'd like to put the sum of
> the first 3 numbers in Row1 into cell A2.
>
> Cell A8 has the value "2", which means we'd like to look at the row of
> data and pick up where the first formula left off (the fourth position in
> the row, cell A4), and sum the value in the 2 cells.
>
> So, in this simple example, cell A2 would result in a value of 95
> (10+35+50), and cell B2 would result in a value of 32 (7+25)
>
> Then, cell C2 would pick up where the previous formula left off and go for
> a certain number of cells....
>
> Thanks for your help!!!! this has been a sticking point for hours.
>
> Cheers,
>
> Scot B.
>