Help Writing a SUM Formula

  • Thread starter Thread starter s7out
  • Start date Start date
S

s7out

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 roadcausing 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 need a formula to sum up ((C2+D2+E2)+(H2+I2+J2)+(M2+N2+O2)+ETC..... butthen 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.
Click to expand...

I think you would need to develop an elaborate sumproduct formula or a userdefined function macro. Send a file direct to me if desired.
 
... 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 evenmore 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.
Click to expand...

Sure. How do I send you the file?
 
... 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 evenmore 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.
Click to expand...

Sure. How do I send you the file?
 
I need a formula to sum up ((C2+D2+E2)+(H2+I2+J2)+(M2+N2+O2)+ETC..... butthen 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.
Click to expand...

dguillett @gmail.com
 
I need a formula to sum up ((C2+D2+E2)+(H2+I2+J2)+(M2+N2+O2)+ETC..... butthen 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.
Click to expand...

use

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