Dear All,

I have used absolute references in Excel for many years without any
issues. Today, however, I have come across a problem I have never seen
before.

I have a fomula in cell N162.

The formula is: =SUM($L108:N108)/SUM($L106:N$106)*7

The problem I have is this:

When I drag down or copy this forlmula to cell N163 the following
formula is created:

=SUM($L109:N109)/SUM($L$106:N107)*7

The '$' sign has now gone from the N$106 reference and has been changed
to N107. I required the N$106 to remain the same.

You may suggest that I change it to $N$106, but as I also need to drag
the formula to the cells on the left (and create O$106), I don't
require the column reference to be absolute.

Any suggestions? I do have my formula syntax correct don't I? I don't
recall ever running into this problem before!!

Thanks in advance....

punter1000