Help, my sparse hair is becoming even more endangered. We are using Excel XP. Using Autosum I get a total for A1:D1 in I1 and a total for E1:H1 in J1. Simples but, after entering values in A1,B1,C1 and D1 and getting the total in I1, a value entered in E1, F1, G1 or H1 is not only totalled in J1, but is also added onto the original total in I1. If values are entered into E1:H1 before entering values in A1:D1 everything works fine. However we do not always get the second group of values for entering before the first group are available.
What is even more puzzling is that for the first 100 or so rows it all worked properly but now, whether we copy the formulae down or enter a new formula for each row we get the same problem.
Doesn't seem to help because, whilst it lets you keep to two ranges for the first row, the formulae cannot be copied down because of the absolute cell references, which means that the formulae in each row have to be typed in seperately - we are currently on row 249!