0
0
Figmabi_tool~10 mins

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

Choose your learning style9 modes available
Sample Data

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

CellValue
A1Component Name
B1Category
C1Status
D1Usage Count
A2Button Primary
B2Buttons
C2Published
D2150
A3Button Secondary
B3Buttons
C3Published
D380
A4Input Text
B4Form Elements
C4Draft
D440
A5Checkbox
B5Form Elements
C5Published
D560
A6Modal Window
B6Overlays
C6Published
D630
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
Test your understanding
Which components are included in the sum?
AOnly components with Status 'Draft'
BOnly components with Status 'Published'
CAll components regardless of Status
DComponents with Usage Count over 50
Key Result
SUMIF(range_condition, condition, range_sum) sums values in range_sum where range_condition meets condition.