1

In my attribute table, I have over 200 fields and tens of thousands of rows or attributes. I am trying to sum the values in each field across each row. This seems like a basic function but when I search for this topic, I've only found instructions on summing entire fields. I could just select each individual field with a "+" in between in the field calculator but there has to be a simpler way than that.

  • 2
    The "simpler" way would be to write some ArcPy/Python code. Perhaps using ArcPy's ListFields and Python's .join("+"). – PolyGeo Sep 29 '16 at 9:44
  • 1
    Databases and spreadsheets are very different animals. 10k rows is a tiny database table, and 200 columns is ungainly latge. Maybe you should be using a spreadsheet. – Vince Sep 29 '16 at 10:46
  • The issue I'm having with the spreadsheet is that Arc freezes whenever I try to join that file to my attribute table and populate the sum field using the field calculator. I figured there might be an easier way – GISLBJ Sep 29 '16 at 19:54
2

In the field calculator there isn't a simpler way as far as I know. I do not think that it is common to want to sum every field in a row without being selective of the fields to be summed. Python could be used in the field calculator to do this, but you would end up writing code that is better to run in a script.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.