Real-time multiplayer editing in Figma - Cell-by-Cell Formula Trace

Sample Data

This data shows a log of user actions in a real-time multiplayer editing session in Figma, with timestamps.

Cell	Value
A1	User
B1	Action
C1	Timestamp
A2	Alice
B2	Added Shape
C2	10:00:01
A3	Bob
B3	Moved Shape
C3	10:00:03
A4	Alice
B4	Changed Color
C4	10:00:05
A5	Charlie
B5	Deleted Shape
C5	10:00:07

Formula Trace

COUNTIF(A2:A5, "Alice")

Step 1: Range A2:A5 values = ["Alice", "Bob", "Alice", "Charlie"]

Step 2: Check each value if it equals "Alice"

Step 3: Count TRUE values in the list

Cell Reference Map

    A       B             C
1 | User  | Action      | Timestamp
2 | Alice | Added Shape | 10:00:01
3 | Bob   | Moved Shape | 10:00:03
4 | Alice | Changed Color | 10:00:05
5 | Charlie | Deleted Shape | 10:00:07

Formula references cells A2 to A5 to count occurrences of "Alice".

The formula counts how many times 'Alice' appears in the User column from A2 to A5.

Result

    A       B             C
1 | User  | Action      | Timestamp
2 | Alice | Added Shape | 10:00:01
3 | Bob   | Moved Shape | 10:00:03
4 | Alice | Changed Color | 10:00:05
5 | Charlie | Deleted Shape | 10:00:07

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

The result shows that Alice performed 2 actions in the editing session.

Sheet Trace Quiz - 3 Questions

How many actions did Alice perform according to the formula?

A 3

B 1

C 2

D 4

Key Result

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