In cell C1
=SUM(INDIRECT("B1:B"&A1)
copy down through C2:C3

--
Regards
Roger Govier
"Richard Buttrey" wrote in
message ...
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
Grappenhall, Cheshire, UK
__________________________