Forum Discussion
Putting totals at top of column - inconsistent formulas
My spreadsheet has about 8 columns. Each column is totaled on line 8 under the heading. I add new entries to individual columns by inserting new lines on line 10, which moves everything down and keep...
Ken1122 Not sure I can visualise exactly what you are describing, but you could consider to include an empty row in the sum range, directly below the SUM formula. Inserting rows directly below the empty row will fix the start of the sum range to the header row and automatically expand the sum range at the bottom. See example attached.
Riny_van_Eekelen What I need to do is use a formula that will automatically sum the entire column rather than using a numerical formula designating the cells. Is that possible? Thanks