Sumif functions in excel the start row of formula keeps changing itself
Posted on 2011-10-17
I have a workbook template where we enter the data each week and there is a summary sheet using sumif functions. I've checked the functions on the template and they are perfect
I did have the formula selecting the whole column ie B, but the calculations were too much for my colleagues computer to cope with so she kept getting NUM errors. Therefore I selected a range big enough for the data rows which can vary from week to week. There is a really strange problem in that on the first row of the sumif column the formulas keep changing themselves to be instead of starting $B$1 to say $B$10 so some of the data is missing from the calculation. On the Monday sheet there is data above this row, so I cannot figure out how or why the formulas are changing themselves - its definitely happening as I have to change it back again and again once the data has been input on each sheet - has anybody any idea and how to fix?
My colleague is using Office 2003. I have tried redoing and saving in 2003 and 2010 compatibility mode.