View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
LuisE LuisE is offline
external usenet poster
 
Posts: 133
Default circular reference when using dynamic rage

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