How to use SUMIF formula in Autocad Table

[Boopathy_Karthikeyan]

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  

[leothebuilder]

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

[pendean · Accepted solution]

SUMIF is not supported in an AutoCAD table.

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

[Boopathy_Karthikeyan]

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.  

[pendean]

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]

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.       

[john.vellek · Accepted solution]

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.

[Boopathy_Karthikeyan]

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