As Example I want Cell C1 to hold SUM of all rows starting from A1 till Ax,
x is changing and stored in cell B1.
Cell C1=SUM(A1:Ax) When x=100, cell B1=100,Cell C1=SUM(A1:A100)
(Basically want to replace 100 with B1 value)
How to do this is with formula in Excel.
Thanks.
Bookmarks