add calculation result to next blank cell in column

Occasional Visitor

Microsoft 365

I have a column where the top cell is the result of a calculation which changes, and the bottom cell totals the rest of the column. I want each calculation to automatically go to the next blank cell in the column. So if A1 =5 I want A2 to equal 5 then if the input to A1 changes and A1 = 6 I want A3 to =6, and so on.

0 Replies