[timmerk]

I have an Excel spreadsheet that I'm using to monitor my weight loss. In one column, I enter my weight each day; one day per row. I want to add a "Lost so far:" field, but not sure of a function in Excel that I can specify a range of cells or column and it spits how the last row with a number in it. Any ideas?

Thanks!

[moonmonkey]

Why not just calculate the sum of the column for "lost so far:"?

Also try to swap bread and pasta for vegetables, and make sure you eat something for breakfast!

[Shades of Gray]

This will tell you row of the last cell used in Column B

=MATCH(9.99999999999999E+307,B:B)


And this will tell you the value of that last cell

=INDEX(B:B,MATCH(9.99999999999999E+307,B:B))

and this will

[timmerk]

moon monkey: its not a column - its just one field that shows how much i lost all together

shades of gray - thanks! what were you going to say after the last "and this will"?

[Shades of Gray]

I think I was combining two thoughts, and forgot to erase the last part.

But that happens when you are an old codger.

So, were those two formulas what you needed?

[timmerk]

Well "=INDEX(B:B,MATCH(9.99999999999999E+307,B:B))" worked in Google Spreadsheets once, but then when i tried typing another number into the next empty row, it showed an error of "N/A Did not find value 999999999...." and so on. Any ideas?

Thanks!