Variant matrix organization in Figma - Cell-by-Cell Formula Trace

Sample Data

This data shows a product variant matrix with products, colors, sizes, and prices.

Cell	Value
A1	Product
B1	Color
C1	Size
D1	Price
A2	T-Shirt
B2	Red
C2	Small
D2	15
A3	T-Shirt
B3	Red
C3	Medium
D3	17
A4	T-Shirt
B4	Blue
C4	Small
D4	15
A5	T-Shirt
B5	Blue
C5	Medium
D5	17

Formula Trace

SUMIFS(D2:D5, B2:B5, "Red", C2:C5, "Small")

Step 1: Check rows where Color = "Red" and Size = "Small"

Step 2: Sum Price values in matching rows

Cell Reference Map

     A        B        C        D
1 | Product | Color  | Size   | Price
2 | T-Shirt | Red    | Small  | 15   
3 | T-Shirt | Red    | Medium | 17   
4 | T-Shirt | Blue   | Small  | 15   
5 | T-Shirt | Blue   | Medium | 17   

Arrows: Formula checks B2:B5 for 'Red' and C2:C5 for 'Small', sums D2:D5 where both match.

The formula uses the Color and Size columns to filter rows, then sums the Price column for those rows.

Result

     A        B        C        D        E
1 | Product | Color  | Size   | Price | Result
2 | T-Shirt | Red    | Small  | 15    | 15
3 | T-Shirt | Red    | Medium | 17    |   
4 | T-Shirt | Blue   | Small  | 15    |   
5 | T-Shirt | Blue   | Medium | 17    |   

The result 15 appears next to the matching row, showing the sum of prices for Red and Small variants.

Sheet Trace Quiz - 3 Questions

Which rows does the formula include in the sum?

A All rows where Size is Small

B Only rows where Color is Red and Size is Small

C All rows where Color is Red

D All rows regardless of Color or Size

Key Result

SUMIFS sums values in one column based on multiple criteria in other columns.

Practice

1. What is the main purpose of a variant matrix in Figma design systems?

easy

A. To organize design options by properties and values for easy comparison

B. To create animations between different frames

C. To export designs as code automatically

D. To generate random color palettes

Solution

1. Step 1: Understand variant matrix concept

   A variant matrix groups design variants by their properties and values, making it easy to compare and switch between them.

2. Step 2: Identify the main purpose

   This organization helps designers quickly find and manage different design options without confusion.

3. Final Answer:

   To organize design options by properties and values for easy comparison -> Option A

4. Quick Check:

   Variant matrix = organize design options [OK]

Hint: Think: variant matrix = organized design choices [OK]

Common Mistakes:

• Confusing variant matrix with animation tools
• Thinking it exports code automatically
• Assuming it generates colors

2. Which of the following is the correct way to name a property in a Figma variant matrix?

easy

A. Color-Option

B. Size

C. 123Style

D. background color

Solution

1. Step 1: Review naming rules for properties

   Property names should be clear, simple, and avoid spaces or special characters that cause confusion.

2. Step 2: Evaluate options

   "Size" is a clear, simple name without spaces or special characters. "Color-Option" has a hyphen which is discouraged. "123Style" starts with numbers which is not recommended. "background color" has a space which is not ideal.

3. Final Answer:

   Size -> Option B

4. Quick Check:

   Clear, simple property name = Size [OK]

Hint: Use simple, no-space names for properties [OK]

Common Mistakes:

• Using spaces in property names
• Starting names with numbers
• Including special characters like hyphens

3. Given a variant matrix with properties Size (Small, Medium) and Color (Red, Blue), how many variants will be created?

medium

A. 6

B. 3

C. 2

D. 4

Solution

1. Step 1: Count values per property

   Size has 2 values: Small, Medium. Color has 2 values: Red, Blue.

2. Step 2: Calculate total variants

   Total variants = number of Size values x number of Color values = 2 x 2 = 4.

3. Final Answer:

   4 -> Option D

4. Quick Check:

   2 x 2 = 4 variants [OK]

Hint: Multiply counts of property values for total variants [OK]

Common Mistakes:

• Adding instead of multiplying values
• Ignoring one property's values
• Counting only unique values

4. You created a variant matrix but Figma shows overlapping variants. What is the most likely cause?

medium

A. You forgot to name the variant set

B. You used too many properties

C. Properties have duplicate values causing conflicts

D. Variants are not grouped in a frame

Solution

1. Step 1: Understand overlapping variants issue

   Overlapping variants usually happen when two or more variants share the exact same property values, causing Figma to not distinguish them.

2. Step 2: Identify cause

   Duplicate property values in different variants cause conflicts and overlap in the matrix.

3. Final Answer:

   Properties have duplicate values causing conflicts -> Option C

4. Quick Check:

   Duplicate property values = overlapping variants [OK]

Hint: Check for duplicate property values to fix overlaps [OK]

Common Mistakes:

• Assuming too many properties cause overlap
• Thinking grouping in frames fixes variant overlap
• Believing naming variant sets prevents overlap

5. You want to organize a button component with variants for Size (Small, Medium, Large), Color (Primary, Secondary), and State (Default, Hover, Disabled). How many variants will your matrix contain, and what is the best way to arrange them for easy use?

hard

A. 18 variants; arrange properties in order of importance (Size, Color, State)

B. 9 variants; arrange properties alphabetically

C. 6 variants; arrange properties randomly

D. 27 variants; arrange properties by frequency of use (State, Color, Size)

Solution

1. Step 1: Calculate total variants

   Size has 3 values, Color 2, State 3. Total variants = 3 x 2 x 3 = 18.

2. Step 2: Determine best arrangement

   Arrange properties logically by importance or how users think about them. Size, then Color, then State is clear and intuitive.

3. Final Answer:

   18 variants; arrange properties in order of importance (Size, Color, State) -> Option A

4. Quick Check:

   3 x 2 x 3 = 18; logical order = Size, Color, State [OK]

Hint: Multiply all property values; order by importance [OK]

Common Mistakes:

• Multiplying incorrectly or adding values
• Arranging properties alphabetically without logic
• Ignoring property importance for arrangement