SUM and AVERAGE functions in Power BI - Cell-by-Cell Formula Trace

Sample Data

This table shows sales and costs data for three products.

Cell	Value
A1	Sales
A2	100
A3	200
A4	300
B1	Costs
B2	50
B3	80
B4	70

Formula Trace

SUM(A2:A4) + AVERAGE(B2:B4)

Step 1: SUM(A2:A4)

Step 2: AVERAGE(B2:B4)

Step 3: 600 + 66.6667

Cell Reference Map

    A       B
1 |Sales | Costs |
2 | 100  |  50   |
3 | 200  |  80   |
4 | 300  |  70   |

SUM uses cells A2, A3, A4
AVERAGE uses cells B2, B3, B4

The formula uses sales values from A2 to A4 and cost values from B2 to B4.

Result

    A       B       C
1 |Sales | Costs | Result |
2 | 100  |  50   |        |
3 | 200  |  80   |        |
4 | 300  |  70   | 666.67 |

The result 666.67 is shown in cell C4, which is the sum of sales plus average of costs.

Sheet Trace Quiz - 3 Questions

What is the result of SUM(A2:A4)?

A 600

B 500

C 300

D 700

Key Result

SUM(range) adds all numbers in the range; AVERAGE(range) calculates the mean of numbers in the range.