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"
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
__________________________