Formula follows the most recent entry in a column???

Giganews Newsgroups
Subject: Formula follows the most recent entry in a column???
Posted by:  lb303910
Date: Thu, 4 May 2006

I have a simple formula =sum(a16), that I use to collect data from cell A16
and place it in cell B32.  If I were to add data to A17 (and eventually A18,
A19, A20, etc.) how would I structure a formula to automatically collect the
data from the next cell every time I make a new entry and place that data in
B32 without rewriting the original formula each time to specify the next cell?

Thanks in advance for your help.

lb303910

Replies