Thanks for the quick response! This formula worked pretty well except for if
a month was skipped, then it would lag behind a month when the next months
input was made. I ended up being able to use the formula that JE McGimpsey
provided as it handled the blanks a little better.
--
smither fan


"JE McGimpsey" wrote:

In that case, one way:

=INDEX(B1:B12,COUNT(B1:B12))

In article ,
Ross wrote:

Sorry folks. Please disregard the zero part. I was thinking about another
part of the spreadsheet.

Thanks