Summing a variable range of columns

Roger,

Brilliant. Thanks.

Sorry to be a pest but do you have any thoughts on the second example,
where I want to sum either the 1st, 1st & 4th or 1st, 4th & 7th
columns in the B:J range depending on the A value


TIA


On Thu, 28 Jul 2005 11:50:08 +0100, "Roger Govier"
<roger@technologyNOSPAM4u.co.uk> wrote:

>Richard
>It wasn't you causing confusion, it was me misreading.
>In cell K1
>=SUM(B1:OFFSET(B1,0,A1-1))
>and copy down

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

Richard
In L1
=CHOOSE(--SUM(A1>=7,A1>=4)+1,B1,(B1+E1),(B1+E1+H1))
copy down

--
Regards
Roger Govier
"Richard Buttrey" <chaos.theory.nospam.removethis@zen.co.uk> wrote in
message news:pbihe1l293sn7r6koh3vlv45f4k5r8sm69@4ax.com...
> Roger,
>
> Brilliant. Thanks.
>
> Sorry to be a pest but do you have any thoughts on the second example,
> where I want to sum either the 1st, 1st & 4th or 1st, 4th & 7th
> columns in the B:J range depending on the A value
>
>
> TIA
>
>
> On Thu, 28 Jul 2005 11:50:08 +0100, "Roger Govier"
> <roger@technologyNOSPAM4u.co.uk> wrote:
>
>>Richard
>>It wasn't you causing confusion, it was me misreading.
>>In cell K1
>>=SUM(B1:OFFSET(B1,0,A1-1))
>>and copy down
>
> __
> Richard Buttrey
> Grappenhall, Cheshire, UK
> __________________________

Richard
In L1
=CHOOSE(--SUM(A1>=7,A1>=4)+1,B1,(B1+E1),(B1+E1+H1))
copy down

--
Regards
Roger Govier
"Richard Buttrey" <chaos.theory.nospam.removethis@zen.co.uk> wrote in
message news:pbihe1l293sn7r6koh3vlv45f4k5r8sm69@4ax.com...
> Roger,
>
> Brilliant. Thanks.
>
> Sorry to be a pest but do you have any thoughts on the second example,
> where I want to sum either the 1st, 1st & 4th or 1st, 4th & 7th
> columns in the B:J range depending on the A value
>
>
> TIA
>
>
> On Thu, 28 Jul 2005 11:50:08 +0100, "Roger Govier"
> <roger@technologyNOSPAM4u.co.uk> wrote:
>
>>Richard
>>It wasn't you causing confusion, it was me misreading.
>>In cell K1
>>=SUM(B1:OFFSET(B1,0,A1-1))
>>and copy down
>
> __
> Richard Buttrey
> Grappenhall, Cheshire, UK
> __________________________