I have an Excel spreadsheet and would like to sum the numbers in a column starting at one cell (say,
B5) 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.
I saw this Superuser question - Excel: is it possible to sum an entire column without setting explicit cell boundaries? - which provides a solution for summing all of the numbers in a column via the following formula:
Problem is, I don't want to sum all of the numbers, just those starting in B5 and down.