The version I'm using is Microsoft Office 2007 for Home and Student. What I
want to do is create a floating cell that always reflects total sum for a
list of numbers that I'm constantly adding to. I want this cell to be
viewable at all times as I add more and move further down the spreadsheet.
Is there a way to do this?

hi, !

The version I'm using is Microsoft Office 2007 for Home and Student.
What I want to do is create a floating cell that always reflects total sum for a list of numbers
that I'm constantly adding to. I want this cell to be viewable at all times
as I add more and move further down the spreadsheet.
Is there a way to do this?

op1: make (i.e.) [A1] "the cell" where your formula resides
select [B2] and use (tab) view / freeze panes (not floating, but fixed)

op2: do a copy for your cell (wherever it is) and paste an image (wherever it be)
and use code to make that shape to follow your window scrolling

hth,
hector.