0
0
Power BIbi_tool~10 mins

Custom visuals from marketplace in Power BI - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

Sales data showing salesperson names and their sales amounts.

CellValue
A1Salesperson
B1Sales
A2Alice
B25000
A3Bob
B37000
A4Carol
B46000
Formula Trace
SUM(B2:B4)
Step 1: B2 + B3 + B4
Step 2: 18000
Cell Reference Map
    A       B
1 Salesperson Sales
2 Alice       5000
3 Bob         7000
4 Carol       6000

Formula references cells B2, B3, and B4 for sales amounts.
The formula sums the sales values in cells B2, B3, and B4.
Result
    A       B       C
1 Salesperson Sales   Total Sales
2 Alice       5000   18000
3 Bob         7000
4 Carol       6000

Cell C2 shows the result of the formula SUM(B2:B4).
The total sales of 18000 is displayed in cell C2, calculated by summing sales in B2 to B4.
Sheet Trace Quiz - 3 Questions
Test your understanding
Which cells does the formula SUM(B2:B4) add together?
AB2, B3, B4
BA2, A3, A4
CB1, B2, B3
DA1, B1, C1
Key Result
SUM(range) adds all numeric values in the specified cell range.