In other words you want the *last* value in the range that is not 0?

Are there any negative numbers in the range?
Are there any empty cells in the range?
Are there any TEXT entries in the range?

If the answer to all those questions is NO, try this:

=IF(COUNTIF(A1:L1,0)<12,LOOKUP(2,1/(A1:L10),A1:L1),"")

--
Biff
Microsoft Excel MVP


"Ken" wrote in message
...
A row of 12 cells representing 12 months, all of which have an initial
value of zero. Each month a value is inserted into one cell, with the
value
remaining as each month passes. There is another cell in a separate
worksheet into which I want to place the most recently entered value from
the 12 cell row, i.e. it will overwrite the previous value.

I've tried using 'if' statements and various formula listed in the Help
files but without success. Can anyone offer a solution please?