=LOOKUP(2,1/(A3:M3<""),A3:M3)

adapt to fit your range

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"George W. Barrowcliff" wrote in message
...
I have a row of numbers (Jan, Feb ..... Total)
I would like the last column (Total) to reflect the last non blank value
in the row.

I would appreciate any help or direction.

Thanks