hi
what kind of data? numeric? text?
you would probably need a dynamic named range to sum.
see this site.
http://www.ozgrid.com/Excel/DynamicRanges.htm

it explains the process.

regards
FSt1

"iamjbunni" wrote:

I need to create a formula that automatically moves to the next cell
containing data. I update reports weekly and want a summary formula to
include the "new" data in the cell below. Any suggestions?