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

Grappenhall, Cheshire, UK

__________________________

## Bookmarks