Is it possible to sum an entire column without setting explicit cell boundaries in Excel?
Problem
I'd like to sum all the values in a column starting from a certain minimum value, but I don't want to give an upper bound because any value in the table will be appropriate for summing (minus the header of course) and I'd like to do it the "right" way instead of summing . Is this possible?
Error Output
A2:A65535
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Fix for: Is it possible to sum an entire column without setting explicit cell boundaries in Excel?
Just leave off the row numbers: Note that this expression cannot be placed in column A (that would cause an endless recursive summation which Excel won't allow). If you instead wanted to sum all of the rows in column A above the current row (say 51) you could do this: If you ever move the cell that holds that expression it would change the A50 to whatever is above the current cell while keeping the starting point of the summation (A1) the same. The same thing can be done if the total is kept ab…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix