=SUM(INDIRECT("Sheet1!A1:"&CHAR(A1+64)&"1"))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ant Nutting" wrote in message
...
Hope someone can help, me problem is this:
In Sheet 1, i have columns A to L, which have information in them. In
sheet
2 i need to get the sum of the contents of columns, starting with A.
However
i would like the qty of columns to be regulated by the figure i put in
Sheet
2 cell A1. Here's an example:
If SHEET 2 CELL A1 = 3, then i would like Sum of SHEET 1 Column A to C.
OR
If SHEET 2 CELL A1 = 7, then i would like Sum of SHEET 1 Column A to G.
I hope someone can understand this and is able to help me.
Thx
Ant