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
|