Fixed elements in prototypes in Figma - Cell-by-Cell Formula Trace

Sample Data

This table shows UI elements in a prototype with their screen positions and whether they are fixed (stay visible when scrolling).

Cell	Value
A1	Element
B1	Position
C1	Fixed
A2	Header
B2	Top
C2	Yes
A3	Sidebar
B3	Left
C3	No
A4	Footer
B4	Bottom
C4	Yes
A5	Content
B5	Center
C5	No

Formula Trace

COUNTIF(C2:C5, "Yes")

Step 1: C2:C5 values = ["Yes", "No", "Yes", "No"]

Step 2: COUNTIF(C2:C5, "Yes") counts how many cells equal "Yes"

Cell Reference Map

    A       B       C
1 |Element|Position|Fixed |
2 |Header |Top     |Yes   |
3 |Sidebar|Left    |No    |
4 |Footer |Bottom  |Yes   |
5 |Content|Center  |No    |

The formula references cells C2 to C5 to check which elements are fixed.

Result

    A       B       C       D
1 |Element|Position|Fixed |Count Fixed|
2 |Header |Top     |Yes   |          |
3 |Sidebar|Left    |No    |          |
4 |Footer |Bottom  |Yes   |          |
5 |Content|Center  |No    |          |
6 |       |        |      |2         |

The count of fixed elements (2) is shown in cell D6, summarizing how many UI parts stay visible when scrolling.

Sheet Trace Quiz - 3 Questions

How many elements are fixed in the prototype?

A 1

B 2

C 3

D 4

Key Result

COUNTIF(range, "Yes") counts how many cells in the range have the value "Yes".