Tom’s Tutorials For Excel: Dynamic Summing From the Active Cell
Here’s a cool formula that you can plug into any cell, which will dynamically sum a list of numbers from the top of the list to the cell of the row the formula is in.
For example, in the picture, cell C11 holds the formula
=SUM(B$3:INDEX(B:B,ROW()))
which sums the numbers in range B3:B11.
Hi Tom,
once again I was able to pick up some pieces of Excel-Knowledge from you! Many thanks! As I now understand the SUM Formula, it actually calculates the Sum in two steps. It first analyzes the Range and builds an array out of that range, then it sums the values in that array. That must be how it is possible to make the sum formula dynamic.
Cheers, Lukas
Hi Lukas, thanks for following my blog and for your kind words!
Cool, handy, thanks for sharing.