How to create formula for cell Value from cell in other sheet by input row Number ?

Question

I want user only in put row number to start to Calculate data -&gt; How to create formula for cell Value from cell in other sheet by input only row Number ?&nbsp;Sheet A : Have data in many rowsRow&nbsp; &nbsp; &nbsp; A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;D&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; E1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; XXX&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 72&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DDD&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3.53&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;BBB&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;24&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; JJJ&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1.33&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ...&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ...&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ...&nbsp;at Sheet B : Want user in put only Row number to be Value from row sheet A&nbsp;&nbsp;For userSheet =&nbsp; &nbsp; &nbsp; ARow =&nbsp; &nbsp; &nbsp; &nbsp; xx &lt;- User&nbsp; Input only row number&nbsp; to Start for sum&nbsp;&nbsp;At sheet Bcell C10 =SUM(C11:C999)cell C11&nbsp;Start Value&nbsp;at cell C11 Start Value from Sheet A=A!Bxx&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;- How to create formulas or Function like this requirement ?=A!B(row xx+1)&nbsp; &nbsp;&nbsp;&lt;- How to create formulas or Function like this requirement ?=A!B(row xx+2)=A!B(row xx+3)&nbsp; &nbsp;...&nbsp; &nbsp;...&nbsp; &nbsp;...&nbsp;Thank you very much🙂

oliverscheurich · Accepted Answer

SomchaiSomjui2011&nbsp;=SUM(INDIRECT("'"&amp;C1&amp;"'!"&amp;"C"&amp;D1&amp;":"&amp;"C"&amp;E1))Is this what you are looking for? In sheet A you can dynamically enter the row number in cells D1 and E1.&nbsp;

Forum Discussion

How to create formula for cell Value from cell in other sheet by input row Number ?

2 Replies

Resources