sum multiple fields

195
5
Jump to solution
2 weeks ago
MauroRoma
New Contributor II

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

M.

Tags (2)
0 Kudos
1 Solution

Accepted Solutions
MauroRoma
New Contributor II
5 Replies
Ed_
by MVP Regular Contributor
MVP Regular Contributor

The Summary Statistics tool will do the trick 🙂

Question | Analyze | Visualize
JoshuaBixby
MVP Esteemed Contributor

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

0 Kudos
MauroRoma
New Contributor II

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

0 Kudos
Ed_
by MVP Regular Contributor
MVP Regular Contributor

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 

Question | Analyze | Visualize
0 Kudos
MauroRoma
New Contributor II

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

see you!

thanks

MR