Anuncios

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

Anonymous
1837 Vistas, 4 Respuestas

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

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
en respuesta a: Anonymous

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:

schurthing
en respuesta a: Anonymous

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:
Anonymous
en respuesta a: schurthing

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
en respuesta a: Anonymous

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