0
0
Figmabi_tool~10 mins

Installing and managing plugins in Figma - Formula Evaluation Walkthrough

Choose your learning style9 modes available
Sample Data

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

CellValue
A1Plugin Name
B1Status
C1Action
A2Color Picker
B2Installed
C2Open
A3Icon Finder
B3Not Installed
C3Install
A4Chart Maker
B4Installed
C4Open
A5Wireframe Tool
B5Not Installed
C5Install
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
Test your understanding
How many plugins are installed according to the formula?
A1
B2
C3
D4
Key Result
COUNTIF(range, "criteria") counts how many cells in the range match the criteria.