FG
💻 Software

Sum contents in column from starting cell on down without setting an explicit last cell index

Fresh6 days ago
Mar 15, 202655904 views
Confidence Score0%
0%

Problem

I have an Excel spreadsheet and would like to sum the numbers in a column starting at one cell (say, ) and continuing down to the last number in that column. I know I could just enter a large ending index, like: But ideally I could just say something like: And it would sum from B5 all the way down.…

Error Output

SUM(B5:B99999)

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Sum contents in column from starting cell on down without setting an explicit last cell index

Low Risk

I came up with a hack that works and isn't super ugly... Insert a blank column before B, which will become the new B Merge the B and C cells above the row you want to start the SUM In cell C:1 paste the forumla =SUM(C:C) Hide column B I don't know w…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment