Currently Being ModeratedDec 1, 2012 8:22 AM (in response to Vangel.eu)
There are many different ways to do this. The easiest one requires that there be no blank rows in the list. COUNT(ColumnID) will give you the number of rows with values in that column and you can use an INDEX, OFFSET or INDIRECT function to address that last row based on knowing how many rows have content.
Currently Being ModeratedDec 4, 2012 11:17 AM (in response to Jerrold Green1)
Thank you Jerry, this solved my problem. Now all my incomes and expenses are well organized. Too bad I don't know how to change "this helped me" to "this solved my question".