Thanks Aladin,

Unfortunately, the function didn't work as I had hoped. It sounds like
F1 is the bottom cell and it would add all the cells above it.
Unfortunately, the bottom cells location varies everyday and I don't
always know it.

An Example of my situation would be:

=SUM(function) <-Cell X (Always known)
a
b
c
d
e