Could expand following for column A ..its crude and only works if unpopulated
rows are empty

=IF(ISBLANK(A3),IF(ISBLANK(A2),IF(ISBLANK(A1),0,A1 ),A2),A3)

"Cyberwolf" wrote:

I have a spreadsheet that has a set number of rows 59 in this case. What
happens is each day an new row is populated with data i.e. today row 30 is
populated tomorrow 31 is populated. At the bottom is a totals column. What
I want is to have that total at the bottom to only show the info from the
last populated row i.e. today will will show the totals from row 30 and
tomorrow from row 31. Is there a formula that I can populated the bottom row
with to check this out?

TIA
--
Cyberwolf
Finder of Paths, Hunter of Prey
Ghost of the Night, Shadow of Day
The Wolf