On Thu, 28 Jul 2005 13:07:22 +0100, Richard Buttrey
wrote:

Ron,

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

Thanks for your input.

Rgds

You're welcome.

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

should work just fine. Copy/Drag down as needed.

You also asked about, 1; 1&4; 1&4&7 depending on contents of A1.

I'm not certain of the relationship between A1 and your three choices.

Since 1-9 are already spoken for, I suppose you could use A, B, & C for your
three choices.

Or did you have something else in mind?


--ron