Hiya guys and gals

i need to make my cell m20, the same value as the last figure entered
in cells a20:n20.

eg. if a20 =200, B20=400, C20=800 and the rest are blank then N20
should be 800

hope i have explained this okay

Regards

James


--
superkopite
------------------------------------------------------------------------
superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496
View this thread: http://www.excelforum.com/showthread...hreadid=492006