just worked that out myself as well, but make sure you have no cells containing numbers at least as far away from the last number in your summed range or it will be added on to the sum. so if L2=5 you are summing in range A1:K1, L1:O1 mustn't have numbers in.