Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
Using a simple formula "SUM" the formula change himself Test this anywhere in a sheet: For this example I will use A1 to A15 In cells A16 type: =sum(A1:A10) In Cells A17 Type: =sum(A11:A15) Now start to type number 1 in cell A1 than A2 and so on. The sum in cell A16 are ok until you reach A10 If you type 1 in row A11 the sum in cell A17 show 1 and now the formula in cellA16 change himself and show 11 instead of 10. a1 1 a2 1 a3 1 a4 1 a5 1 a6 1 a7 1 a8 1 a9 1 a10 1 a11 1 a12 a13 a14 a15 11 This is at the beginning =sum(A1:A10) After entering the 1 in the cell A11 the formula change 1 This is at the beginning =sum(A11:A15) Do you have a patch for this or this is new ? Bye |