Forum Discussion
formula for excel
I have money amounts in a column that are entered daily. I.E. A1 100000, A2 101000 etc.. I want to be able to automatically transfer the amount entered that day to a another cell I.E. B4. So as I ent...
The formula in cell B4 displays the 18 from cell A8 in cell B4.
If you enter for example 107 in cell A9, the formula in B4 will show 107 in B4.
If you then enter for example 274 in cell A10, the formula in B4 will show 274 in B4.
The same was done when i entered the numbers in cells A1:A7.
OK so I entered it exactly how you said except I changed the A to B because that's where the columns reside. Confused about the arrayformula reference.