On Thu, 28 Jul 2005 10:13:36 +0100, Richard Buttrey
wrote:

Can anyone suggest a formula to do the following

Whe

A1 = 6
A2 = 3
A3 = 9

B1:J1 = 1,2,3,4,5,6,7,8,9
B2:J2 = 1,2,3,4,5,6,7,8,9
B3:J3 = 1,2,3,4,5,6,7,8,9

Formulae in C1:C3 to do the following:

In C1 I want to add the first 6 (the 6 is defined by A1) cells in the
range B1:J1 and result in the number 21

In C2 I want to add the first 3 (the 3 is defined by A2) cells in the
range B1:J1 and result in the number 6

In C3 I want to add the first 9 (the 9 is defined by A3) cells in the
range B1:J1 and result in the number 45

Usual TIA


Regards



__
Richard Buttrey

It's not possible as the conditions you specify set up a circular reference; in
addition, you cannot have both the number '2' and a formula in the same cell
(column C).

If you would care to purt your formulas in other than C1:C3, you could use the
formula:

=SUM(OFFSET(B1,,,,A1))

for Row 1 and copy/drag down as needed.

If you want something else, or really want to use a circular reference, I'd
need more details of exactly what you are trying to accomplish.


--ron