Home » Forums » Open Source Learning Center » Question and Answer

Build a Sum formula with dynamic ranges

Submitted by philly on 22 August, 2014 - 17:36

Hi, I am looking to build a sum formula at the bottom of a column that has a constant starting cell (row 3), but the end of the column of numbers can vary. I want to build a sum formula at the bottom of this column, that can account for a varying number of rows.

‹ Unable to convert custom/text column to number Count Conditional Format Cells with complex formulas ›
»
akmughal's picture

Build a sum formula with dynamic ranges

Submitted by akmughal on 23 August, 2014 - 16:21.

say the last row in your 'D' column is 100. Then put =SUM(D3:OFFSET(D100,-1,0)) in D101.If you insert any row before formula it will count for automatically.

»

Build a Sum formula with dynamic ranges

Submitted by philly on 25 August, 2014 - 16:11.

Thank you!
But how would I handle it if I don't want to arbitrarily fix a end row, like D100, but would rather let excel figure out what that end row is, then drop down a row and build a sum formula based on that dynamic end row?

»