Try something like this:

With a list of values (or blanks) in A1:L1

The value of the last non-blank cell in that range is
M1: =INDEX(A1:L1,MAX(MATCH(10^99,A1:L1),MATCH(REPT("z" ,255),A1:L1)))

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"George W. Barrowcliff" wrote:

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