Anuncios

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

Boopathy_Karthikeyan
1651 Vistas, 7 Respuestas

How to use SUMIF formula in Autocad Table

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

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

pendean
en respuesta a: Boopathy_Karthikeyan

SUMIF is not supported in an AutoCAD table.

Data Link your Excel spreadsheet with SUMIF to your DWG file instead.
Boopathy_Karthikeyan
en respuesta a: pendean

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

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.

Boopathy_Karthikeyan
en respuesta a: pendean

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

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

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