Bird
0
0
PCB Designbi_tool~10 mins

Power symbols and ground connections in PCB Design - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

This table shows two integrated circuits (IC1 and IC2) with their pins and the type of power connection each pin has: VCC (power) or GND (ground).

CellValue
A1Component
B1Pin
C1Connection
A2IC1
B21
C2VCC
A3IC1
B32
C3GND
A4IC2
B41
C4VCC
A5IC2
B52
C5GND
Formula Trace
COUNTIF(C2:C5, "GND")
Step 1: Range C2:C5 values = ["VCC", "GND", "VCC", "GND"]
Step 2: Count how many times "GND" appears in ["VCC", "GND", "VCC", "GND"]
Cell Reference Map
    A       B       C
1 |Component| Pin   | Connection
2 |IC1      | 1     | VCC
3 |IC1      | 2     | GND  <---
4 |IC2      | 1     | VCC
5 |IC2      | 2     | GND  <---
The formula references cells C2 to C5 to count how many pins are connected to ground (GND). The arrows point to the GND connections counted.
Result
    A       B       C       D
1 |Component| Pin   | Connection | Ground Count
2 |IC1      | 1     | VCC       | 
3 |IC1      | 2     | GND       | 
4 |IC2      | 1     | VCC       | 
5 |IC2      | 2     | GND       | 2
The result '2' in cell D5 shows the total number of ground (GND) connections found in the range C2:C5.
Sheet Trace Quiz - 3 Questions
Test your understanding
How many pins are connected to ground (GND) in the data?
A3
B2
C1
D4
Key Result
COUNTIF(range, "criteria") counts how many cells in the range match the criteria.