circular reference when using dynamic rage

's Computer Specifications

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

's Computer Specifications

Change the COUNT part to

COUNT(Sheet1!$A$2:$A$65536)-1
--
HTH,
Barb Reinhardt

"LuisE" wrote:

> 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

's Computer Specifications

Thanks a lot

"Barb Reinhardt" wrote:

> Change the COUNT part to
>
> COUNT(Sheet1!$A$2:$A$65536)-1
> --
> HTH,
> Barb Reinhardt
>
>
>
> "LuisE" wrote:
>
> > 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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Dynamic Rage - Drill down	Jennifer	Microsoft Excel Worksheet Functions	3	18th Dec 2008 12:22 PM
Circular Reference	=?Utf-8?B?bmFzdGVjaA==?=	Microsoft Excel Misc	1	27th Apr 2006 12:54 AM
how to: circular reference	=?Utf-8?B?VGlt?=	Microsoft Excel Worksheet Functions	0	11th Mar 2005 12:37 AM
Circular Reference	Fons Ponsioen	Microsoft Access Reports	0	29th Apr 2004 08:26 PM
Re: circular reference	Andy B	Microsoft Excel Worksheet Functions	2	9th Sep 2003 05:26 PM