Calculate a running total

You can use a running total to watch the values of items in cells add up as you enter new items and values over time.

Use the provided sample data and the following procedures to learn how to calculate a running total and then extend the calculation to a list of transactions, such as an account register.

Step 1: Copy the sample data

To better understand the steps, copy the following sample data to cell A1 on a blank sheet.

  1. Create a blank workbook or sheet.

  2. Select the following sample data.

    Bemærk: Do not select the row or column headings (1, 2, 3...  A, B, C...) when you copy the sample data to a blank sheet.

    Selecting sample data in Help

    Vælg eksempeldata

Date

Transaction

Deposits

Withdrawals

Balance

11/1/2007

Beginning Balance

 1500

11/4/2007

City Power & Light

35.71

11/5/2007

The Phone Company

33.38

11/5/2007

Northwind Traders

51.22

11/7/2007

Wide World Importers

62.39

11/7/2007

Fabrikam, Inc.

46.77

  1. Press KOMMANDO + C .

  2. In the sheet, select cell A1, and then press KOMMANDO + V .

Step 2: Create a formula to calculate the running total

  1. Click cell E3, which is the first blank cell in the Balance column.

  2. To create a formula that adds the value from the Deposits column in the same row and subtracts the value from the Withdrawals column, type =SUM(E2,C3,-D3).

  3. Press RETURN .

    The result is 1464.29, which is 1500.00 - 35.71.

    Bemærk: You can ignore the error indicator about formulas that refer to empty cells.

  4. To copy the formula to other rows that contain data, select E3, and then drag the fyldhåndtag to cell E7.

    Excel adjusts the cell references as you copy the formula to each cell in the Balance column.

    Bemærkninger: 

    • You can ignore the Auto Fill Options button that appears.

    • As you add new rows of deposits and withdrawals, drag the fill handle again to copy the running total formula to the new rows.

See also

Calculate an average

Calculate percentages

Del Facebook Facebook Twitter Twitter Mail Mail

Var disse oplysninger nyttige?

Fantastisk! Har du mere feedback?

Hvordan kan vi forbedre det?

Tak for din feedback!

×