Export and handoff plugins in Figma - Cell-by-Cell Formula Trace

Sample Data

This table lists popular Figma export and handoff plugins with their main functions and output formats.

Cell	Value
A1	Plugin Name
B1	Function
C1	Output Format
A2	Zeplin
B2	Export designs and specs for developers
C2	CSS, iOS, Android code snippets
A3	Avocode
B3	Handoff with code and assets
C3	CSS, SVG, PNG, JPG
A4	Figma Inspect
B4	Built-in handoff tool
C4	Code snippets, measurements
A5	LottieFiles
B5	Export animations
C5	JSON animation files

Formula Trace

COUNTIF(B2:B5, "*handoff*")

Step 1: Check B2: "Export designs and specs for developers" contains "handoff"

Step 2: Check B3: "Handoff with code and assets" contains "handoff"

Step 3: Check B4: "Built-in handoff tool" contains "handoff"

Step 4: Check B5: "Export animations" contains "handoff"

Step 5: COUNTIF result = count of True values in steps 2 and 3

Cell Reference Map

    A           B                              C
1 | Plugin Name | Function                     | Output Format
2 | Zeplin      | Export designs and specs for developers | CSS, iOS, Android code snippets
3 | Avocode     | Handoff with code and assets             | CSS, SVG, PNG, JPG
4 | Figma Inspect| Built-in handoff tool                    | Code snippets, measurements
5 | LottieFiles | Export animations                        | JSON animation files

Arrows point from B2:B5 to the COUNTIF formula cell.

The formula references cells B2 to B5 to check for the word 'handoff' in the Function column.

Result

    A           B                              C                   D
1 | Plugin Name | Function                     | Output Format        | Count of 'handoff'
2 | Zeplin      | Export designs and specs for developers | CSS, iOS, Android code snippets | 
3 | Avocode     | Handoff with code and assets             | CSS, SVG, PNG, JPG             | 
4 | Figma Inspect| Built-in handoff tool                    | Code snippets, measurements    | 
5 | LottieFiles | Export animations                        | JSON animation files           | 
6 |            |                                  |                           | 2

Cell D6 shows the formula result: 2

The final count of plugins mentioning 'handoff' in their function is 2, shown in cell D6.

Sheet Trace Quiz - 3 Questions

How many plugins mention 'handoff' in their Function description?

A 3

B 2

C 1

D 4

Key Result

COUNTIF(range, "*text*") counts cells containing the specified text anywhere.