topic Re: Getting the sum of attribute values. in AutoCAD Forum

Getting the sum of attribute values.

mlfgale — Thu, 18 May 2017 15:53:35 GMT

We have blocks that we use for defect locations. The block has an attribute for a number that is the linear feet (or sf) of a defect area. Is there a way to get the sum of the attribute for all of the blocks into a table? I've messed around with fields and found a script that can do it, but I'd like to not have to use a script each time (which makes me have to select the defects, and there are many different ones) to update it when we add more defects. Thanks for any help you can provide.

Mark

Re: Getting the sum of attribute values.

ВeekeeCZ — Thu, 18 May 2017 16:09:47 GMT

Explorer the DATAEXTRACTION command

Re: Getting the sum of attribute values.

john.vellek — Fri, 19 May 2017 19:18:08 GMT

HI @mlfgale,

@ВeekeeCZ's suggestion of Dataextraction is what I suggest as well. If you have a sample file that contains this data I am happy to explore and demonstrate how you might get this to work.

Please select the Accept as Solution button if my post solves your issue or answers your question.

Re: Getting the sum of attribute values.

john.vellek — Fri, 19 May 2017 19:30:58 GMT

HI @mlfgale,

I haven't seen an update so I created an attributed block, ran a data extraction and then exported to Excel to add the SUM. In addition, if you select the last row of the table and insert a row below it, unlock it, then you can add a formula that will create the SUM. No need to even export outside of the drawing file!

Please select the Accept as Solution button if my post solves your issue or answers your question.

Re: Getting the sum of attribute values.

mlfgale — Fri, 19 May 2017 19:47:26 GMT

Thanks for your help!

Re: Getting the sum of attribute values.

ВeekeeCZ — Fri, 19 May 2017 19:56:59 GMT

HERE is quite a recent thread how to sum a table column within autocad and dynamically.