0
0
Google Sheetsspreadsheet~10 mins

Sheets with Google Data Studio (Looker) in Google Sheets - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

Sales data by date and region used to connect with Google Data Studio (Looker) for visualization.

CellValue
A1Date
B1Sales
C1Region
A22024-06-01
B2150
C2North
A32024-06-02
B3200
C3South
A42024-06-03
B4180
C4East
A52024-06-04
B5220
C5West
Formula Trace
=SUM(B2:B5)
Step 1: B2:B5
Step 2: SUM(150, 200, 180, 220)
Cell Reference Map
     A        B        C
1  Date     Sales    Region
2  2024-06-01 150  -->  North
3  2024-06-02 200  -->  South
4  2024-06-03 180  -->  East
5  2024-06-04 220  -->  West

Arrows show data used in formula SUM(B2:B5).
The formula references sales data in cells B2 to B5 to calculate total sales.
Result
     A        B        C
1  Date     Sales    Region
2  2024-06-01 150  North
3  2024-06-02 200  South
4  2024-06-03 180  East
5  2024-06-04 220  West
6           750
The sum of sales from B2 to B5 is 750, shown in cell B6 as the total sales.
Sheet Trace Quiz - 3 Questions
Test your understanding
What does the formula =SUM(B2:B5) calculate?
AThe sales on June 5
BThe average sales from June 1 to June 4
CThe total sales from June 1 to June 4
DThe number of sales entries
Key Result
SUM(range) adds all numbers in the specified cell range.