Why reference types affect formula behavior in Google Sheets - Formula Trace Breakdown

Sample Data

This sheet has two columns of numbers (A and B). Column C will show sums using different reference types in formulas.

Cell	Value
A1	10
A2	20
A3	30
B1	5
B2	15
B3	25
C1
C2
C3

Formula Trace

=A1+B$1

Step 1: A1

Step 2: B$1

Step 3: 10 + 5

Cell Reference Map

    A    B    C
1 | 10 |  5 |    |
2 | 20 | 15 |    |
3 | 30 | 25 |    |

Formula in C1 references A1 (relative) and B$1 (mixed: absolute row 1).

Result

    A    B    C
1 | 10 |  5 | 15 |
2 | 20 | 15 | 25 |
3 | 30 | 25 | 35 |

Column C sums values from columns A and B. The mixed reference B$1 keeps row 1 fixed when formula is copied down, so B$1 always points to B1 (5).

Sheet Trace Quiz - 3 Questions

What value does B$1 refer to when the formula is in cell C2?

A C1 (empty)

B B2 (15)

C B1 (5)

D A2 (20)

Key Result

Mixed references like B$1 keep the row fixed when copied, affecting how formulas calculate as they move.