PC Review


Reply
Thread Tools Rate Thread

circular reference when using dynamic rage

 
 
=?Utf-8?B?THVpc0U=?=
Guest
Posts: n/a
 
      20th Nov 2007
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
 
Reply With Quote
 
 
 
 
=?Utf-8?B?QmFyYiBSZWluaGFyZHQ=?=
Guest
Posts: n/a
 
      21st Nov 2007
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

 
Reply With Quote
 
=?Utf-8?B?THVpc0U=?=
Guest
Posts: n/a
 
      21st Nov 2007
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

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:57 PM.