| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
circular reference when using dynamic rage
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
circular reference when using dynamic rage
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Rage - Drill down | Excel Worksheet Functions | |||
| Circular Reference - Why? | Excel Discussion (Misc queries) | |||
| Circular Reference | Excel Discussion (Misc queries) | |||
| Circular Reference | Excel Programming | |||
| Circular reference | Excel Programming | |||
Hybrid Mode
