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.