Hello Everyone, I have a formula in one of the cells in my Excel. Formula is =SUM(B1:B6)-B12 B12 has a formula which is =SUM(B7:B11)
Problem - When I insert 2 rows, one at B2 and the other one at B9 I expect the formula to be =SUM(B1:B7)-B14 and B12 formula to be =SUM(B8:B13) Actual result - Formula =SUM(B1:B8)-B14 and B12 formula is =SUM(B8:B13) The formula should not consider the second row inserted into B1:B6 range. First part of formula should only consider the rows added in that range only. Because of this actual formula is =SUM(B1:B8)-B14 Any suggestions are welcome. Thanks in Advance, Bhavani Gandham
