0
0
Google Sheetsspreadsheet~8 mins

Relative references in Google Sheets - Dashboard Guide

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Dashboard Mode - Relative references
Goal

See how relative references help copy formulas easily to calculate total prices for different products.

Sample Data
ProductPriceQuantityTotal Price
Apples25
Bananas1.58
Cherries34
Dates46
Elderberries53
Dashboard Components
  • KPI Card: Total Revenue
    Formula: =SUM(D2:D6)
    Shows total money earned from all products.
  • Table: Product Total Price Calculation
    Formula in D2: =B2*C2
    Copy this formula down to D6 to calculate total price for each product using relative references.
Dashboard Layout
+----------------------+----------------------+
| Product Table         | Total Revenue (KPI)  |
| (with relative refs)  |                      |
+----------------------+----------------------+
Interactivity

When you change the quantity or price for any product, the total price updates automatically because the formula uses relative references. The total revenue KPI also updates to reflect the new sum.

Self Check

If you change the price of Bananas from 1.5 to 2, which cells update and what happens to the total revenue?

Key Result
Calculate total prices per product using relative references and show total revenue.