James

one way:

=OFFSET($A20,,COUNTA($A20:$M20)-1)

You seem to have confused m20 and n20 along the way. The above answer
assumes that n20 follows m20 and that's what you meant.

Regards

Trevor


"superkopite"
wrote in message
...

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