0
0
Power BIbi_tool~10 mins

Table and matrix layouts in Power BI - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

Sales data by Region and Product

CellValue
A1Region
B1Product
C1Sales
A2North
B2Apples
C2100
A3North
B3Oranges
C3150
A4South
B4Apples
C4200
A5South
B5Oranges
C5120
Formula Trace
SUM(Sales)
Step 1: Sales values: 100, 150, 200, 120
Cell Reference Map
  A       B         C
1 Region  Product  Sales
2 North   Apples   100
3 North   Oranges  150
4 South   Apples   200
5 South   Oranges  120

Cells C2 to C5 are referenced for Sales values.
The formula sums the Sales column values from cells C2 to C5.
Result
  A       B         C
1 Region  Product  Total Sales
2 North   Apples   100
3 North   Oranges  150
4 South   Apples   200
5 South   Oranges  120
6                  570
The total sales sum 570 is shown below the sales data in the Sales column.
Sheet Trace Quiz - 3 Questions
Test your understanding
What does the formula SUM(Sales) calculate here?
AThe total of all sales numbers in the Sales column
BThe average sales per product
CThe number of sales entries
DThe highest sales value
Key Result
SUM(column) adds all numeric values in the specified column.