0
0
Google Sheetsspreadsheet~10 mins

Sheets API basics in Google Sheets - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

This sheet lists products and their prices.

CellValue
A1Product
B1Price
A2Apple
B21.20
A3Banana
B30.80
A4Cherry
B42.50
Formula Trace
=SUM(B2:B4)
Step 1: B2:B4
Step 2: SUM([1.20, 0.80, 2.50])
Cell Reference Map
    A       B
1 |Product | Price
2 | Apple  | 1.20  <-- referenced
3 | Banana | 0.80  <-- referenced
4 | Cherry | 2.50  <-- referenced
The formula references cells B2, B3, and B4 which contain the prices.
Result
    A       B
1 |Product | Price
2 | Apple  | 1.20
3 | Banana | 0.80
4 | Cherry | 2.50
5 | Total  | 4.50
The formula in cell B5 sums the prices from B2 to B4 and shows the total 4.50.
Sheet Trace Quiz - 3 Questions
Test your understanding
What does the formula =SUM(B2:B4) calculate?
AThe total of all prices in cells B2 to B4
BThe average price of products
CThe highest price in the list
DThe number of products listed
Key Result
SUM(range) adds all numbers in the specified cell range.