Component library organization in Figma - Cell-by-Cell Formula Trace

Sample Data

This data represents a component library in Figma with components, their categories, publication status, and usage count.

Cell	Value
A1	Component Name
B1	Category
C1	Status
D1	Usage Count
A2	Button Primary
B2	Buttons
C2	Published
D2	150
A3	Button Secondary
B3	Buttons
C3	Published
D3	80
A4	Input Text
B4	Form Elements
C4	Draft
D4	40
A5	Checkbox
B5	Form Elements
C5	Published
D5	60
A6	Modal Window
B6	Overlays
C6	Published
D6	30

Formula Trace

=SUMIF(C2:C6, "Published", D2:D6)

Step 1: Check each cell in C2:C6 if value equals "Published"

Step 2: Select corresponding values from D2:D6 where condition is TRUE

Step 3: Sum the selected values: 150 + 80 + 60 + 30

Cell Reference Map

    A               B               C               D
1 | Component Name | Category      | Status       | Usage Count
2 | Button Primary| Buttons       | Published    | 150
3 | Button Secondary| Buttons     | Published    | 80
4 | Input Text    | Form Elements | Draft        | 40
5 | Checkbox     | Form Elements | Published    | 60
6 | Modal Window | Overlays      | Published    | 30

Arrows: C2:C6 (Status) and D2:D6 (Usage Count) feed into the formula

The formula uses the Status column (C2:C6) to check for 'Published' and sums the Usage Count (D2:D6) for those rows.

Result

    A               B               C               D
1 | Component Name | Category      | Status       | Usage Count
2 | Button Primary| Buttons       | Published    | 150
3 | Button Secondary| Buttons     | Published    | 80
4 | Input Text    | Form Elements | Draft        | 40
5 | Checkbox     | Form Elements | Published    | 60
6 | Modal Window | Overlays      | Published    | 30
7 | Total Usage of Published Components: 320

The result 320 is shown below the data, representing the total usage count of all published components.

Sheet Trace Quiz - 3 Questions

Which components are included in the sum?

A Only components with Status 'Draft'

B Only components with Status 'Published'

C All components regardless of Status

D Components with Usage Count over 50

Key Result

SUMIF(range_condition, condition, range_sum) sums values in range_sum where range_condition meets condition.