Anuncios

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

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

Anonymous

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

Anonymous
No aplicable

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

 

0 Me gusta
Responder
1.841 Vistas
4 Respuestas
Respuestas (4)

lovecraft
Collaborator
Collaborator

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 :cara_con_los_ojos_en_blanco:

0 Me gusta

schurthing
Advocate
Advocate

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.

Stefanie
crazy autocad witch since release 8 :cara_que_ríe_con_la_boca_abierta_y_los_ojos_sonrientes:
0 Me gusta

Anonymous
No aplicable

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

0 Me gusta

vamler
Explorer
Explorer

@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. 

0 Me gusta