sum of column cells(fields) in autocad table is ####

[Anonymous]

Hi,

I am having trouble summing up all cells in column (which are fields). There can be any number of rows.

The SUM function somehow does not work. =Sum (C3:C4) does not work. But =C3+C4 works.

SUM function works when its just text instead of fields. I searched almost everything but I could not find solution.

I hope somebody has a solution.

The drwing is attached. it is 2007 format.

regards

[lovecraft]

Well, just like you, I would like an answer.  I converted the fields in your table to text - then your formula works.  You probably already know this, right?  Looks like you did this two columns over to the right - then the formula that you prefer, using the SUM format works the way you want it to.  Anybody out there have any ideas?

LC 🙄

[schurthing]

The SUM function only work on numerical data. The referenced data (from the blocks) in the cells are formatted as text strings instead of numerical.

[Anonymous]

Thank you for reply.

I was wondering why this simple thing is not considered by Autocad!

See attached drawing. In Area and perimeter columns in window schedule, Field values are summed up.

I dont know how it is different from what I want. I am using Acad 2007. Is it available in newer version?

Ragards

[vamler]

@Anonymous : if you choose the cells and change the cell style to data and then apply the formula. It maintains the fields and provides the solution.