Thats because when you copied down you left the absolute referencing in
place!, try this copied down:
=IF(AND($J4=0,$J4<4),$J4,"")

The column will remain absolute but the row will be relative.


--
The Code Cage Team

Regards,
The Code Cage Team
http://www.thecodecage.com
------------------------------------------------------------------------
The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=31333