Schematic editor interface in PCB Design - Cell-by-Cell Formula Trace

Sample Data

This table lists electronic components with their pin counts and operating voltages used in a schematic editor interface.

Cell	Value
A1	Component
B1	Pin Count
C1	Voltage
A2	Resistor
B2	2
C2	5V
A3	Capacitor
B3	2
C3	16V
A4	Microcontroller
B4	32
C4	3.3V
A5	LED
B5	2
C5	2V

Formula Trace

=SUM(B2:B5)

Step 1: B2:B5

Step 2: SUM([2, 2, 32, 2])

Cell Reference Map

    A           B           C
1 |Component | Pin Count | Voltage
2 |Resistor  | ->2       | 5V
3 |Capacitor | ->2       | 16V
4 |Microcontroller | ->32      | 3.3V
5 |LED       | ->2       | 2V

The formula references cells B2 to B5 which contain pin counts of components.

Result

    A           B           C
1 |Component | Pin Count | Voltage
2 |Resistor  | 2         | 5V
3 |Capacitor | 2         | 16V
4 |Microcontroller | 32        | 3.3V
5 |LED       | 2         | 2V
6 |Total Pins| 38        |

The sum of pin counts (38) is displayed in cell B6 labeled as Total Pins.

Sheet Trace Quiz - 3 Questions

What does the formula =SUM(B2:B5) calculate?

A Total number of pins of all components

B Total voltage of all components

C Number of components listed

D Average pin count

Key Result

SUM(range) adds all numeric values in the specified cell range.