topic Re: sum multiple fields in ArcGIS Pro Questions

sum multiple fields

MauroRoma — Fri, 03 May 2024 13:56:40 GMT

hi to everyone,

in arcgis Pro 3.1, how can I sum many numeric fields of a table. I want to insert the sum, or other statistical operations, of 180 fields (horizontally) into a new field, is there a tool already set up that allows me to do this?
Thank you and greetings

Re: sum multiple fields

Ed_ — Fri, 03 May 2024 13:59:59 GMT

The Summary Statistics tool will do the trick 🙂

Re: sum multiple fields

JoshuaBixby — Fri, 03 May 2024 14:06:13 GMT

I believe the OP wants to sum over all columns for each row, which is the opposite of what Summary Statistics does.

Re: sum multiple fields

MauroRoma — Fri, 03 May 2024 14:14:03 GMT

Yes, exactly

my goal is exactly the opposite of Summary Statistics does. Apparently it is so simple but i can't find a appropriate tool

thanks

Re: sum multiple fields

Ed_ — Fri, 03 May 2024 14:17:06 GMT

Oh I see yeah you are right I thought OP wanted to get sum of each column.

Pivot table and then Summary Statistics might do it

Re: sum multiple fields

MauroRoma — Fri, 03 May 2024 16:12:39 GMT

Done!

I found the following amazing technical support:

https://support.esri.com/en-us/knowledge-base/how-to-calculate-the-sum-of-all-numeric-attribute-field-000029132

see you!

thanks