0
0
Figmabi_tool~10 mins

Effect styles in Figma - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
Sample Data

This table shows UI elements and their assigned effect styles in Figma.

CellValue
A1Element
B1Effect Style
A2Button
B2Drop Shadow
A3Card
B3Inner Shadow
A4Modal
B4Blur
A5Icon
B5Drop Shadow
Formula Trace
COUNTIF(B2:B5, "Drop Shadow")
Step 1: Range B2:B5 values = ["Drop Shadow", "Inner Shadow", "Blur", "Drop Shadow"]
Step 2: Check each value if it equals "Drop Shadow"
Step 3: Count how many true values are in the list
Cell Reference Map
    A          B
1 | Element   | Effect Style |
2 | Button   | Drop Shadow  |
3 | Card     | Inner Shadow |
4 | Modal    | Blur         |
5 | Icon     | Drop Shadow  |
The formula references cells B2 to B5 to count how many have the 'Drop Shadow' effect style.
Result
    A          B          C
1 | Element   | Effect Style | Count Drop Shadow
2 | Button   | Drop Shadow  | 2
The result shows that 2 elements have the 'Drop Shadow' effect style.
Sheet Trace Quiz - 3 Questions
Test your understanding
How many elements have the 'Drop Shadow' effect style?
A3
B2
C1
D4
Key Result
COUNTIF(range, criteria) counts how many cells in the range match the criteria.