Base component architecture in Figma - Cell-by-Cell Formula Trace

Sample Data

This data represents a simple list of base components in a design system with their types, properties, and variants.

Cell	Value
A1	Component Name
B1	Type
C1	Properties
D1	Variants
A2	Button
B2	Base Component
C2	Color, Size, Text
D2	Primary, Secondary, Disabled
A3	Icon
B3	Base Component
C3	Type, Size, Color
D3	Filled, Outline
A4	Input Field
B4	Base Component
C4	Placeholder, Size, State
D4	Default, Focused, Error

Formula Trace

COUNTIF(B2:B4, "Base Component")

Step 1: B2:B4 values = ["Base Component", "Base Component", "Base Component"]

Step 2: COUNTIF(B2:B4, "Base Component") counts how many cells equal "Base Component"

Cell Reference Map

    A           B               C                  D
1 |Component Name|Type           |Properties         |Variants
2 |Button        |Base Component |Color, Size, Text  |Primary, Secondary, Disabled
3 |Icon          |Base Component |Type, Size, Color  |Filled, Outline
4 |Input Field   |Base Component |Placeholder, Size, State|Default, Focused, Error

Arrows: Formula references cells B2, B3, B4

The formula references the Type column cells B2 to B4 to count how many are 'Base Component'.

Result

    A           B               C                  D
1 |Component Name|Type           |Properties         |Variants
2 |Button        |Base Component |Color, Size, Text  |Primary, Secondary, Disabled
3 |Icon          |Base Component |Type, Size, Color  |Filled, Outline
4 |Input Field   |Base Component |Placeholder, Size, State|Default, Focused, Error
5 |              |Count of Base Components: 3

The result of the formula COUNTIF(B2:B4, "Base Component") is 3, showing there are three base components listed.

Sheet Trace Quiz - 3 Questions

How many cells in B2:B4 contain the text 'Base Component'?

A 3

B 2

C 1

D 0

Key Result

COUNTIF(range, criteria) counts how many cells in the range meet the criteria.