Net labels for connections in PCB Design - Cell-by-Cell Formula Trace

Sample Data

This table shows components with their pins and assigned net labels representing electrical connections.

Cell	Value
A1	Component
B1	Pin
C1	Net Label
A2	U1
B2	1
C2	VCC
A3	U1
B3	2
C3	GND
A4	R1
B4	1
C4	VCC
A5	R1
B5	2
C5	OUT
A6	C1
B6	1
C6	OUT
A7	C1
B7	2
C7	GND

Formula Trace

COUNTIF(C2:C7, "VCC")

Step 1: Range C2:C7 values = ["VCC", "GND", "VCC", "OUT", "OUT", "GND"]

Step 2: COUNTIF over ["VCC", "GND", "VCC", "OUT", "OUT", "GND"] for "VCC"

Cell Reference Map

    A       B       C
1 Component Pin    Net Label
2 U1        1      VCC  <-- included
3 U1        2      GND  <-- included
4 R1        1      VCC  <-- included
5 R1        2      OUT  <-- included
6 C1        1      OUT  <-- included
7 C1        2      GND  <-- included

The formula references cells C2 through C7 to count occurrences of the net label 'VCC'.

Result

    A       B       C
1 Component Pin    Net Label
2 U1        1      VCC
3 U1        2      GND
4 R1        1      VCC
5 R1        2      OUT
6 C1        1      OUT
7 C1        2      GND

Result in D1: 2

The formula counts 2 occurrences of 'VCC' in the net labels from C2 to C7.

Sheet Trace Quiz - 3 Questions

How many times does the net label 'VCC' appear in the range C2:C7?

A 2

B 3

C 1

D 4

Key Result

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