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.

Do the "missing" columns contain anything?
By that I mean, what's in F2 & G2 then K2 & L2?

On Wednesday, July 25, 2012 8:22:27 AM UTC-5, s7out wrote:
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.

I think you would need to develop an elaborate sumproduct formula or a user defined function macro. Send a file direct to me if desired.

On Wednesday, July 25, 2012 10:08:09 AM UTC-4, Don Guillett wrote:
On Wednesday, July 25, 2012 8:22:27 AM UTC-5, s7out wrote:
> 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.

I think you would need to develop an elaborate sumproduct formula or a user defined function macro. Send a file direct to me if desired.

Sure. How do I send you the file?

On Wednesday, July 25, 2012 10:08:09 AM UTC-4, Don Guillett wrote:
On Wednesday, July 25, 2012 8:22:27 AM UTC-5, s7out wrote:
> 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.

I think you would need to develop an elaborate sumproduct formula or a user defined function macro. Send a file direct to me if desired.

Sure. How do I send you the file?

On Wednesday, July 25, 2012 8:22:27 AM UTC-5, s7out wrote:
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.

dguillett @gmail.com

On Wednesday, July 25, 2012 8:22:27 AM UTC-5, s7out wrote:
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.

use

=SUMPRODUCT(--($A$1:$FN$1<"adjustment"),A2:FN2)