Lat populated cell
 

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

Lat populated cell
 

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

Lat populated cell
 

Not 100% sure what you mean by Sum of the last populated row but what I can
tell you is that you are probably looking for the offest function... This
will return the value of the last populated cell in Range A1:A30 (placed in
Cell A31)

=OFFSET(A1,COUNTA(A1:A30)-1,0, 1, 1)

If you want the sum of the last entry in Cell A1:B50 then try this...
(placed in Cell A31)
=SUM(OFFSET(A1,COUNTA(A1:A30)-1,0, 1, 2))

--
HTH...

Jim Thomlinson


"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

Lat populated cell
 

XL is limited to 7 nested if statements so that probably will not work. you
can get around it using named ranges (formulas) but it is kinda cumbersome
and would be a huge pain in this case... check out this link for more info...

http://www.cpearson.com/excel/nested.htm
--
HTH...

Jim Thomlinson


"Nicholas B" wrote:

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

Lat populated cell
 

Nice

"Jim Thomlinson" wrote:

Not 100% sure what you mean by Sum of the last populated row but what I can
tell you is that you are probably looking for the offest function... This
will return the value of the last populated cell in Range A1:A30 (placed in
Cell A31)

=OFFSET(A1,COUNTA(A1:A30)-1,0, 1, 1)

If you want the sum of the last entry in Cell A1:B50 then try this...
(placed in Cell A31)
=SUM(OFFSET(A1,COUNTA(A1:A30)-1,0, 1, 2))

--
HTH...

Jim Thomlinson


"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