Ron,

My apologies for confusing the matter. I should have referred to
column K rather than column C

Thanks for your input.

Rgds



On Thu, 28 Jul 2005 06:39:25 -0400, Ron Rosenfeld
<ronrosenfeld@nospam.org> wrote:

>On Thu, 28 Jul 2005 10:13:36 +0100, Richard Buttrey
><chaos.theory.nospam.removethis@zen.co.uk> wrote:
>
>>Can anyone suggest a formula to do the following
>>
>>Where:
>>
>>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

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________