0
0
Google Sheetsspreadsheet~10 mins

Add-ons and extensions in Google Sheets - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
Sample Data

Sample data showing names and their scores in a test.

CellValue
A1Name
B1Score
A2Alice
B285
A3Bob
B390
A4Charlie
B478
Formula Trace
=SUM(B2:B4)
Step 1: B2:B4
Step 2: SUM(85, 90, 78)
Cell Reference Map
    A       B
1 | Name  | Score |
2 | Alice |  85   |
3 | Bob   |  90   |
4 | Charlie | 78   |

Arrows: B2 -> SUM, B3 -> SUM, B4 -> SUM
Cells B2, B3, and B4 are referenced in the SUM formula to add the scores.
Result
    A       B
1 | Name  | Score |
2 | Alice |  85   |
3 | Bob   |  90   |
4 | Charlie | 78   |
5 | Total |  253  |
The total score 253 is shown in cell B5 after applying the SUM formula.
Sheet Trace Quiz - 3 Questions
Test your understanding
What does the formula =SUM(B2:B4) calculate?
AThe total of scores in cells B2 to B4
BThe average of scores in cells B2 to B4
CThe highest score in cells B2 to B4
DThe lowest score in cells B2 to B4
Key Result
SUM(range) adds all numbers in the specified range of cells.