Anuncios

The Autodesk Community Forums has a new look. Read more about what's changed on the Community Announcements board.

Anonymous
en respuesta a: john.vellek

Sorry for almost 3 years late reply but it is possible to do it while remaining within AutoCAD.

steps would be - 

1. first add 1 rows in the table below the items list. it can be done manually.

2. The newly added vacant cell below the quantities - first unlock it from the property (click the cell to select it and then right-click menu. alternatively can be dome from properties window)

3. Once unlocked, go to the cell, double click it to see the cursor inside the cell, right-click - choose insert field.

4. in the field dialogue-box, choose formula from the "field names" pan in the extreme left.

5. choose "SUM" (present just right to the "field names" pan)

6. the moment you click on the sum, the field dialogue box disappears. the CAD then asks you to choose the cells you want to include in the calculation of the formula (in this case, the sum).

7. just click on the top left corner of the top-most cell and drag it to the bottom right corner of the bottom-most cell which you want to be part of the summation. (note - AutoCAD will not snap at the corner points but it is ok)

8. once you click at the bottom right corner, the field dialogue box will reappear and you will see the there us a formula in the "formula" box which would be something like "SUM(C01:C19)" where "C" is the row of the table.

9. Choose the precision level. in your case it is number of items so it would be whole number hence the precision would be set to 0. in some other cases (like area calculation etc. one may want to set 0.00 or 0.000 etc.)

10. click ok in the field dialogue box and then you will see the sum total of the values of selected cells appearing in the newly added bottom cell.

As general information, most of the basic excel capabilities are well integrated into AutoCAD and that is why it is considered the most robust industry solution.

 

I humbly disagree with you when you said "it is not a spreadsheet or database program". AutoCAD is essentially a full-fledged computer-aided program which not only capable of drawing something to visually communicate design intent, it is also capable to hold, list, manage and manipulate technical information associated with such CAD/CAM activities - in this case keeping a track of each object through attribute in the block and further providing the total number of such objects. without these capabilities, CAD/CAM activities can not be managed and hence are a core feature of AutoCAD. this way, I see AutoCAD essentially as a drawing+database management program.