I need a formula to sum up ((C2+D2+E2)+(H2+I2+J2)+(M2+N2+O2)+ETC..... but then random cells in this formula would eventually get deleted down the road causing the formula to read #ref!. I tried carrying out this formula summing the ranges as I've shown but the cell eventually maxes out and I can't fit the entire formula in the cell. To make this even more challenging, there are numbers in cells B2, G2, L2, ETC.... that shouldn't be reflected in this sum. Thoughts?? Any help would be greatly appreciated.