💻 Software
Sum contents in column from starting cell on down without setting an explicit last cell index
Fresh6 days ago
Mar 15, 202655904 viewsConfidence 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