poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bhavani Kumar" <bhavan...@gmail.com>
Subject Formula updatation problem
Date Thu, 24 Apr 2008 21:23:52 GMT
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
Because of this actual formula is =SUM(B1:B8)-B14
Any suggestions are welcome.

Thanks in Advance,
Bhavani Gandham

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message