Extruded cut in Solidworks - Cell-by-Cell Formula Trace

Sample Data

This table shows three extruded cut features with their cut depths and the volume of material removed. The goal is to calculate the total material removed by summing the volumes.

Cell	Value
A1	Feature
B1	Depth (mm)
C1	Material Removed (mm³)
A2	Extruded Cut 1
B2	10
C2	500
A3	Extruded Cut 2
B3	5
C3	250
A4	Extruded Cut 3
B4	15
C4	750
A5	Total Material Removed
C5	1500

Formula Trace

=SUM(C2:C4)

Step 1: C2:C4 values

Step 2: SUM(500, 250, 750)

Cell Reference Map

    A           B           C
1 | Feature   | Depth (mm) | Material Removed (mm³) |
2 | Extruded Cut 1 | 10      | 500                   |
3 | Extruded Cut 2 | 5       | 250                   |
4 | Extruded Cut 3 | 15      | 750                   |
5 | Total Material Removed       | 1500                  |

Formula references cells C2, C3, and C4 for summing.

The formula sums the values in cells C2, C3, and C4 which represent the volumes of material removed by each extruded cut.

Result

    A           B           C
1 | Feature   | Depth (mm) | Material Removed (mm³) |
2 | Extruded Cut 1 | 10      | 500                   |
3 | Extruded Cut 2 | 5       | 250                   |
4 | Extruded Cut 3 | 15      | 750                   |
5 | Total Material Removed       | 1500                  |

The total material removed by all extruded cuts is 1500 mm³, shown in cell C5 as the sum of C2 through C4.

Sheet Trace Quiz - 3 Questions

Which cells does the formula =SUM(C2:C4) add together?

A B2, B3, and B4

B C2, C3, and C4

C A2, A3, and A4

D C1, C2, and C3

Key Result

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