Anuncios

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

How to use SUMIF formula in Autocad Table

Boopathy_Karthikeyan
Advocate

How to use SUMIF formula in Autocad Table

Boopathy_Karthikeyan
Advocate
Advocate

Hi,

 

How to use the SUMIF formula in Autocad in without any Purchase application.

Generally we have sum, Average, Count etc., But i need to use the SUMIF to for special purpose.

 

I here attached the Table with formula.

 

Thank in advance.

 

Best regards...

Boopathy K  



Best Regards..
Boopathy K
0 Me gusta
Responder
Soluciones aceptadas (2)
1.653 Vistas
7 Respuestas
Respuestas (7)

leothebuilder
Advisor
Advisor

Tables in Autocad are unlike Excel and are limited to formulas you are able to use. 

0 Me gusta

pendean
Community Legend
Community Legend
Solución aceptada
SUMIF is not supported in an AutoCAD table.

Data Link your Excel spreadsheet with SUMIF to your DWG file instead.
0 Me gusta

Boopathy_Karthikeyan
Advocate
Advocate

thanks for your reply.

 

I don't want to use the datalink that why i am trying this method, Why Because this table Column can be increase or reduce i dont want to open excel every time to update the drawing, also i have almost 50 to 60 autocad files for every file i cant maintaining the separate excel sheet for all the drawings its not possible.  

 



Best Regards..
Boopathy K
0 Me gusta

pendean
Community Legend
Community Legend

What you want has no bearing here sadly: it's your only free choice to date within the TABLE features.

 

I'm not seeing an alternate using another custom FIELD option so far, maybe someone else has.

0 Me gusta

Boopathy_Karthikeyan
Advocate
Advocate

I thought there may be will be some solution, If not i will follow my old producer.

 

Here actually i need to calculate the every Feed and Rapid individually, 5 or 10 rows we can but there are more the 25 so i try to reduce my time by using this formula.  

 

But i like to thank you people, for your immediate support.

May be Auto Desk can take care of these type of functions in advance version.       



Best Regards..
Boopathy K

john.vellek
Alumni
Alumni
Solución aceptada

Hi @Boopathy_Karthikeyan,

 

I found this utility in the Autodesk App Store. It appears to give more formula capabilities than are built-in.  I hope this helps.

 

 

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


John Vellek


Join the Autodesk Customer Council - Interact with developers, provide feedback on current and future software releases, and beta test the latest software!

Autodesk Knowledge Network | Autodesk Account | Product Feedback
0 Me gusta

Boopathy_Karthikeyan
Advocate
Advocate

Hi,

 

I aware of this Add-on application,

This i need to purchase, actually i don't know my organization will do this! any way may be this will useful for some other!

 

Thanks John...!



Best Regards..
Boopathy K
0 Me gusta