Installing and managing plugins in Figma - Formula Evaluation Walkthrough

Sample Data

This data shows a list of Figma plugins with their installation status and available actions.

Cell	Value
A1	Plugin Name
B1	Status
C1	Action
A2	Color Picker
B2	Installed
C2	Open
A3	Icon Finder
B3	Not Installed
C3	Install
A4	Chart Maker
B4	Installed
C4	Open
A5	Wireframe Tool
B5	Not Installed
C5	Install

Formula Trace

COUNTIF(B2:B5, "Installed")

Step 1: Check B2: "Installed" matches "Installed"

Step 2: Check B3: "Not Installed" matches "Installed"

Step 3: Check B4: "Installed" matches "Installed"

Step 4: Check B5: "Not Installed" matches "Installed"

Step 5: Sum of matches: 1 + 0 + 1 + 0

Cell Reference Map

    A           B             C
1 | Plugin Name | Status      | Action
2 | Color Picker| Installed   | Open
3 | Icon Finder | Not Installed| Install
4 | Chart Maker | Installed   | Open
5 | Wireframe Tool | Not Installed| Install

Formula references cells B2 to B5 to count 'Installed' statuses.

The formula checks the Status column from B2 to B5 to count how many plugins are installed.

Result

    A           B             C
1 | Plugin Name | Status      | Action
2 | Color Picker| Installed   | Open
3 | Icon Finder | Not Installed| Install
4 | Chart Maker | Installed   | Open
5 | Wireframe Tool | Not Installed| Install

Result cell (e.g., D1): 2

The result shows the number 2, meaning two plugins are currently installed.

Sheet Trace Quiz - 3 Questions

How many plugins are installed according to the formula?

A 1

B 2

C 3

D 4

Key Result

COUNTIF(range, "criteria") counts how many cells in the range match the criteria.