My current code is:
(SUM(INDIRECT(ADDRESS(ROW()-(I4:I- 1);COLUMN()-4;4)&":"&ADDRESS(ROW();COLUMN()-4;4)))*( ( J4:J ) / 10 ))))
I want to sum cells from
Gy but range is determed by cell
I4. My existing code works, but only for one line.
=ArrayFormula( if( J4:J = "" ; "" ;
So if I put
ArrayFormula in front, the calculation is shown only where the data is, but the result is always equal to the result of first row.
Can anyone help me?
You can view my sheet here.