# Calculate running total in Excel and Google Sheets

=SUM(\$A\$2:A3)

### \$A\$2 = fixed cell; A3 = moving/dynamic cell

Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.

# Calculate running total in Excel

How to calculate the running total in Excel? # CALCULATE RUNNING TOTAL — EXCEL FORMULA AND EXAMPLE

=SUM(\$A\$2:A3)

• \$A\$2 = fixed cell

• A3 = moving/dynamic cell

This formula will calculate the running total where \$A\$2 is a fixed cell (keyboard shortcut = F4), and the next row will dynamically move as you drop down the formula.

# Calculate running total in Google Sheets

How to calculate the running total in Google Sheets? # CALCULATE RUNNING TOTAL — GOOGLE SHEETS FORMULA AND EXAMPLE

=SUM(\$A\$2:A3)

• \$A\$2 = fixed cell

• A3 = moving/dynamic cell

This formula will calculate the running total where \$A\$2 is a fixed cell (keyboard shortcut = F4), and the next row will dynamically move as you drop down the formula.