Hi All
I have a cell with the formula in =ROUNDUP(SUM(C28*D28,C29*D29,C30*D30,C31*D31,C32*D32,C33*D33,C34*D34,C35*D35,C36*D36)/0.4,0)
The issue I have if someone adds a row between Row 28 and Row 36, this formula will not include the new row in the calc.
is there a way to simplify it or to ensure any added cells will be included in new calculation
thanks is advance
I have a cell with the formula in =ROUNDUP(SUM(C28*D28,C29*D29,C30*D30,C31*D31,C32*D32,C33*D33,C34*D34,C35*D35,C36*D36)/0.4,0)
The issue I have if someone adds a row between Row 28 and Row 36, this formula will not include the new row in the calc.
is there a way to simplify it or to ensure any added cells will be included in new calculation
thanks is advance