To maintain the running balance, add a row for each new entry by doing the following: Set up a worksheet like the following example.Ĭlick anywhere outside cell C3 to see the calculated total. For more information, see Calculate a running total in Excel. Note: A running balance differs from a running total (also called a running count), in which you watch the number of items in a worksheet add up as you enter new items.