ExcelBanter - circular reference when using dynamic rage

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - circular reference when using dynamic rage (https://www.excelbanter.com/excel-programming/401464-circular-reference-when-using-dynamic-rage.html)

LuisE

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

Barb Reinhardt

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

LuisE

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

All times are GMT +1. The time now is 12:36 PM.