- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2006 May
- Formula follows the most recent entry in a column???

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

- RE: Formula follows the most recent entry in a column??? posted by Ron Coderre on Thu, 4 May 2006
- Re: Formula follows the most recent entry in a column??? posted by Peo Sjoblom on Thu, 4 May 2006