Direction (horizontal, vertical) in Figma - Cell-by-Cell Formula Trace

Sample Data

This data shows sales figures for two quarters arranged vertically in columns A and B.

Cell	Value
A1	Sales Q1
A2	100
A3	150
A4	200
B1	Sales Q2
B2	120
B3	180
B4	210

Formula Trace

SUM(A2:A4)

Step 1: A2 + A3 + A4

Step 2: 450

Cell Reference Map

    A      B
1 |Sales Q1|Sales Q2
2 | 100   | 120   
3 | 150   | 180   
4 | 200   | 210   

Formula references cells A2, A3, A4 vertically.

The formula SUM(A2:A4) uses the vertical range from A2 to A4.

Result

    A      B
1 |Sales Q1|Sales Q2
2 | 100   | 120   
3 | 150   | 180   
4 | 200   | 210   
5 | 450   |       

Cell A5 shows the sum of vertical cells A2 to A4.

The sum of sales for Q1 is displayed in cell A5, showing the total 450.

Sheet Trace Quiz - 3 Questions

What cells does the formula SUM(A2:A4) add together?

A Cells A1, B1, and C1 horizontally

B Cells B2, B3, and B4 vertically

C Cells A2, A3, and A4 vertically

D Cells A2, B2, and C2 horizontally

Key Result

SUM(range) adds all numbers in the specified horizontal or vertical range.