I have a monthly inventory sheet, it has an opening balance column, a couple
of columns for different activity and an ending balance - each row is a day
of the month. Untill today() = the row date (column A), the ending balance
column remains zero.

I have a total row at the bottom for the activity columns, but for the
ending balance column I would like to be able to display the last balance. I
have thought about an IF statement to check each cell until I find a value,
but 31 nested IF's sounds a little crazy.

Ideas?