circular reference when using dynamic rage

[Guest]

I need a total of the column in the first row of it (i.e A1 for column A)
The data begings in cell A3.
This is what I have
=OFFSET(Sheet1!$A$3,0,0,COUNT(Sheet1!$A:$A),1)
it returns ) and the circular reference dialog box.
Any know fix?
Thanks in advance

 

[Guest]

Change the COUNT part to

COUNT(Sheet1!$A$2:$A$65536)-1

 

[Guest]

Thanks a lot

Change the COUNT part to

COUNT(Sheet1!$A$2:$A$65536)-1