Just like we added a formula in the Total price column, we can add another formula that calculates the total cost of components by adding up all the values inside column E. Here are the steps required to do this:
- Select cell E7 and then select Sum from the Formula drop-down menu of the Insert panel of the Table Cell tab, as shown in Figure 7.21.
- Now, click on cell E3 and then click on cell E6. This will include all these cells in our calculation and the formula will be added automatically.
- Click outside the table to finish adding the formula and, once again, you will end up with a formula that shows the sum of all the values in the Total price column:
Figure 7.20: Using the Sum formula in the selected cell
My final table looked like Figure 7.21:
Figure 7. 21: Final table with all the data and formulas in it
In this table, changing any parameter, such as the quantity of any part or its unit price, would update the entire table to always reflect the correct data; this is all possible because of formulas.
So, now our table has been made in AutoCAD and it can be added anywhere in the drawing, but if you want to save this table in a Microsoft Excel-compatible format, then you need to export it using a simple method shown in the next section.