- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Denunciar
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
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Denunciar
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 ![]()
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Denunciar
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.
crazy autocad witch since release 8
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Denunciar
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
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Denunciar
@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.