Sum a dynamic range

[[email protected]]

Hello, Gurus.

I am trying to enter a sum formula in cell T2 that sums all data from U7 to the end of the column. The end of the column is dynamic, and at the bottom of the column there is a blank row folowed by a "TOTALS" row that I don't want included in the sum. I tried this knowing it wouldn't work, but though this may give you an idea of what I am trying to do.

Please Login or Register  to view this content.

One other thing that may confuse me is that the formula is within a "With Sheets" statement. Here is the full section of code, with the bad formula commented out.

Please Login or Register  to view this content.

[FDibbins]

Probably other reasons why, and this may be too simplistic anyway, but why not just a regular formula?

=sum(U:U)/2

[protonLeah]

Please Login or Register  to view this content.

Formula vs. FormulaR1C1

[[email protected]]

Simple is best. I didn't think about totaling the whole row and dividing by 2. Let em try that and I will come back and close the thread if it works for all my formulas. (Yes, there were other formulas, including subtotals, but I figured if I could solve one I could guess at the others.)

[FDibbins]

Looking forward to hearing back from you

[[email protected]]

Sorry for the slow response, guys. Had a "honey do" list when I got home. I tried both examples, and Leah's script worked best for my purposes. It works on both my sums and my subtotals. Below is what I ended up with. Please let me know if there is a more efficient way to execute it. Either way, than for the help to both of you, and this thread is SOLVED.

Please Login or Register  to view this content.

[FDibbins]

Im happy you got where you wanted to be