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

by Tom Urtis 3 Comments ↓

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.

‹ Tom’s Tutorials For Excel: Listing Column Letters Across and Down

Tom’s Tutorials For Excel: Looking Up the Address of an Item in a List ›

Posted in Tom's Tutorials for Excel
Tags: Analytics, Big Data, Business Intelligence, Data Science, Excel Expert, Excel Guru, Formulas Functions, Microsoft, Microsoft Excel, Microsoft MVP, Microsoft Office, Tom Urtis

3 comments on “Tom’s Tutorials For Excel: Dynamic Summing From the Active Cell”

1. Lukas says:

   April 23, 2013 at 12:21 am

   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

   Reply
   • Tom Urtis says:

     April 24, 2013 at 10:23 am

     Hi Lukas, thanks for following my blog and for your kind words!

     Reply
2. Doris Choo says:

   March 22, 2014 at 10:18 am

   Cool, handy, thanks for sharing.

   Reply