Tom’s Tutorials For Excel: Dynamic Summing From the Active Cell

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.

Share Button
Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , ,
3 comments on “Tom’s Tutorials For Excel: Dynamic Summing From the Active Cell
  1. Lukas says:

    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

  2. Doris Choo says:

    Cool, handy, thanks for sharing.

Leave a Reply

Your email address will not be published.

*