Construction geometry usage in Solidworks - Cell-by-Cell Formula Trace

Sample Data

This data represents lengths of edges in a SolidWorks sketch. 'Main Edge' is a regular line with length 100 units. 'Construction Line' is a construction geometry line with length 50 units. The result cell will show the sum of lengths of only regular lines.

Cell	Value
A1	Line1
B1	Length
A2	Main Edge
B2	100
A3	Construction Line
B3	50
A4	Result
B4

Formula Trace

=SUMIF(A2:A3, "<>Construction Line", B2:B3)

Step 1: Check A2: 'Main Edge' <> 'Construction Line'

Step 2: Check A3: 'Construction Line' <> 'Construction Line'

Step 3: Sum values in B2:B3 where condition is TRUE

Step 4: Final result = 100

Cell Reference Map

    A           B
1 | Line1      | Length
2 | Main Edge  | 100  
3 | Construction Line | 50   
4 | Result     |      

Arrows:
A2 -> condition check
A3 -> condition check
B2 -> sum if condition TRUE
B3 -> sum if condition TRUE

Cells A2 and A3 are checked to exclude construction geometry lines. Corresponding B2 and B3 values are summed only if condition is TRUE.

Result

    A           B
1 | Line1      | Length
2 | Main Edge  | 100  
3 | Construction Line | 50   
4 | Result     | 100  

The result cell B4 shows 100, which is the sum of lengths of only regular lines, excluding construction geometry.

Sheet Trace Quiz - 3 Questions

Why is the length of the construction line not included in the sum?

A Because the formula excludes rows where column A equals 'Construction Line'

B Because the length is zero

C Because construction lines have negative length

D Because the formula sums all rows regardless

Key Result

SUMIF(range_to_check, condition, range_to_sum) sums values only where condition is TRUE