Howto apply formula to ongoing column of data

[momo333]

Hi,

How can I apply a formula to an ongoing column of data?

I have a column of values and I want to have a cell in another area of the workbook to have a formula that always updates when I add another value to the end of my column.

Thanks for taking the time to read my question.

 

[RomulusMilea]

Hi Momo333,

Hm, sounds interesting ! Let us have a simple example. What that separate cell is supposed to contain ? Thank you.

 

[Rick Rothstein]

Modify your formula to look at the cell and if it is empty, have it display the empty string (""), otherwise have it display your formula.... then you can copy your formula down past the end of your data (usually down to the row beyond which you ever expect to have data in) and the display will update automatically as new data is entered or old data modified. For example, if you have this in

=MyFomulaLookingAt(A2)

and if Column A is the column with the data you want to monitor, then change your formula to this...

=IF(A2="","",MyFomulaLookingAt(A2))

 

[momo333]

Thank you for the quick reply and good help.