Manufacturing file review in PCB Design - Cell-by-Cell Formula Trace

Sample Data

This table lists manufacturing files for a PCB project, showing file names, types, review status, and error counts.

Cell	Value
A1	File Name
B1	File Type
C1	Status
D1	Errors
A2	board_top.gbr
B2	Gerber
C2	Checked
D2	0
A3	board_bottom.gbr
B3	Gerber
C3	Checked
D3	1
A4	drill_file.drl
B4	Drill
C4	Pending
D4	0
A5	assembly_instructions.pdf
B5	Document
C5	Checked
D5	0

Formula Trace

=COUNTIF(C2:C5, "Checked")

Step 1: C2:C5 values = ["Checked", "Checked", "Pending", "Checked"]

Step 2: Check each cell if value equals "Checked"

Step 3: Count TRUE values

Cell Reference Map

    A               B           C           D
1 | File Name      | File Type | Status    | Errors
2 | board_top.gbr | Gerber    | Checked   | 0
3 | board_bottom.gbr | Gerber  | Checked   | 1
4 | drill_file.drl | Drill     | Pending   | 0
5 | assembly_instructions.pdf | Document | Checked | 0

Formula references cells C2 to C5 for Status values.

The formula counts how many files have the status 'Checked' in the Status column (C2:C5).

Result

    A               B           C           D
1 | File Name      | File Type | Status    | Errors
2 | board_top.gbr | Gerber    | Checked   | 0
3 | board_bottom.gbr | Gerber  | Checked   | 1
4 | drill_file.drl | Drill     | Pending   | 0
5 | assembly_instructions.pdf | Document | Checked | 0

Result cell (e.g., E1): 3

The formula result is 3, showing three files have been reviewed and marked as 'Checked'.

Sheet Trace Quiz - 3 Questions

How many files have the status 'Checked' according to the formula?

A 3

B 2

C 4

D 1

Key Result

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