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