topic Re: How to use SUMIF formula in Autocad Table in AutoCAD Forum

How to use SUMIF formula in Autocad Table

Boopathy_Karthikeyan — Mon, 23 Oct 2017 12:47:02 GMT

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

Re: How to use SUMIF formula in Autocad Table

leothebuilder — Mon, 23 Oct 2017 12:52:22 GMT

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

Re: How to use SUMIF formula in Autocad Table

pendean — Mon, 23 Oct 2017 12:53:27 GMT

SUMIF is not supported in an AutoCAD table.

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

Re: How to use SUMIF formula in Autocad Table

Boopathy_Karthikeyan — Mon, 23 Oct 2017 13:01:26 GMT

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.

Re: How to use SUMIF formula in Autocad Table

pendean — Mon, 23 Oct 2017 13:08:52 GMT

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.

Re: How to use SUMIF formula in Autocad Table

Boopathy_Karthikeyan — Mon, 23 Oct 2017 13:21:08 GMT

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.

Re: How to use SUMIF formula in Autocad Table

john.vellek — Mon, 23 Oct 2017 16:31:14 GMT

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.

Re: How to use SUMIF formula in Autocad Table

Boopathy_Karthikeyan — Tue, 24 Oct 2017 05:20:26 GMT

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