Its difficult to explain but I have this formula on a sheet:
=COUNTIF(Numbers!$A3:Numbers!AE3,1)
I want to be able to insert a collum on the Numbers sheet and put in new
data there without the cell reference $A3 changing to $B3

--

Thank You Much
for taking your time to reply to my post

I understand the problem. It only happens when you insert a column at column
A. If you insert a column to the right of A then it doesn't happen as you
know.
Is that an option?
--
Russell Dawson
Excel Student


"Just Me" wrote:

Its difficult to explain but I have this formula on a sheet:
=COUNTIF(Numbers!$A3:Numbers!AE3,1)
I want to be able to insert a collum on the Numbers sheet and put in new
data there without the cell reference $A3 changing to $B3

--

Thank You Much
for taking your time to reply to my post

I would like to insert the collumn at the first collumn, the data I insert
has a date then other numbers below that, I need to grab the date for 1
calculation then the numbers for others. I would have a simular problem with
the date if it is not in A1
--

Thank You alot
for taking your time to reply to my post


"Russell Dawson" wrote:

I understand the problem. It only happens when you insert a column at column
A. If you insert a column to the right of A then it doesn't happen as you
know.
Is that an option?
--
Russell Dawson
Excel Student


"Just Me" wrote:

Its difficult to explain but I have this formula on a sheet:
=COUNTIF(Numbers!$A3:Numbers!AE3,1)
I want to be able to insert a collum on the Numbers sheet and put in new
data there without the cell reference $A3 changing to $B3

--

Thank You Much
for taking your time to reply to my post

INDIRECT will allow you to always point to the fixed range impervious to
future col insertions/deletions:
=COUNTIF(INDIRECT("'Numbers'!A3:AE3"),1)
The range string: 'Numbers'!A3:AE3 within INDIRECT is just a text string, so
you don't need to use any $ signs. Any worth? hit the YES below.
--
Max
Singapore
---
"Just Me" wrote:
I would like to insert the collumn at the first collumn, the data I insert
has a date then other numbers below that, I need to grab the date for 1
calculation then the numbers for others. I would have a simular problem with
the date if it is not in A1

OK i will experiment with:
=COUNTIF(INDIRECT("'Numbers'!A3":AE3),1)
because the :AE3 part of the range needs to change as I populate the Numbers
sheet.

--

Thank You all Much
for taking your time to reply to my post


"Max" wrote:

INDIRECT will allow you to always point to the fixed range impervious to
future col insertions/deletions:
=COUNTIF(INDIRECT("'Numbers'!A3:AE3"),1)
The range string: 'Numbers'!A3:AE3 within INDIRECT is just a text string, so
you don't need to use any $ signs. Any worth? hit the YES below.
--
Max
Singapore
---
"Just Me" wrote:
I would like to insert the collumn at the first collumn, the data I insert
has a date then other numbers below that, I need to grab the date for 1
calculation then the numbers for others. I would have a simular problem with
the date if it is not in A1

If that's the case, maybe just grab the entire row 3 then?
=COUNTIF(INDIRECT("'Numbers'!3:3"),1)
--
Max
Singapore
---
"Just Me" wrote:
OK i will experiment with:
=COUNTIF(INDIRECT("'Numbers'!A3":AE3),1)
because the :AE3 part of the range needs to change as I populate the Numbers
sheet.