Hi,

To fix the letters (column) put a $ in the right side of letter e.i.: $B3:$W3
To fis the numbers (row) put a $ in the left side of the letter e.i.: B$3:W$3

Thanks,
--
Farhad Hodjat


"Loosey" wrote:

I am trying to auto fill a series, the problem I have is the wrong values are
amended through the series and I cannot see how to correct this. . .

My series to fill is:
=COUNTIF('[2007.xls]Mar 07'!B2:W2,"U")

I want to see:
=COUNTIF('[2007.xls]Mar 07'!B3:W3,"U")
=COUNTIF('[2007.xls]Mar 07'!B4:W4,"U")

What I actually get is:
=COUNTIF('[2007.xls]Mar 07'!C3:X3,"U")
=COUNTIF('[2007.xls]Mar 07'!D3:Y3,"U")

I really want the cell letter to remain the same but the row identifier to
change, however I get the opposite of what I want/need. . . . anyone got any
ideas please???