I don't see why that formula wouldn't work dragged down. Do you maybe have manual calculation turned on? Try pressing F9 and see if it updates.

Also, what cell are you putting that formula into?