Line and centerline tools in Solidworks - Cell-by-Cell Formula Trace

Sample Data

This table shows lengths of lines and centerlines used in a SolidWorks drawing.

Cell	Value
A1	Length
B1	Type
A2	50
B2	Line
A3	30
B3	Centerline
A4	20
B4	Line
A5	40
B5	Centerline

Formula Trace

=SUMIF(B2:B5, "Line", A2:A5)

Step 1: Check B2:B5 for cells equal to "Line"

Step 2: Select corresponding A2:A5 values where condition is TRUE

Step 3: Sum selected values: 50 + 20

Cell Reference Map

    A     B
1 Length  Type
2  50    Line  <-- included
3  30    Centerline
4  20    Line  <-- included
5  40    Centerline

The formula checks cells B2 to B5 for "Line" and sums corresponding A2 to A5 values.

Result

    A     B       C
1 Length  Type    Total Line Length
2  50    Line        70
3  30    Centerline
4  20    Line
5  40    Centerline

The result 70 is the sum of lengths where the type is "Line".

Sheet Trace Quiz - 3 Questions

Which cells in column B are counted by the formula?

A B2 and B4

B B3 and B5

C B2, B3, B4, B5

D Only B2

Key Result

SUMIF(range_to_check, condition, range_to_sum) sums values in range_to_sum where range_to_check meets condition.