I've got a shapefile that was made by the mother of all Unions. Because of that, it's got about 400 columns, and I want to sum about 100 of them (specifically, the "Score" from each). Is there an easier way to do it than to manually type a formula adding each score value?
Before this project is done, there will be about 600 scores that need to be added to one thing or another so any kind of automation would be helpful. I've thought about setting up some kind of iteration through the column names (they're sequentially numbered) but I don't know how to do that. I've also thought about turning off all the fields other than the scores (no fun) and then summing all values for each row (which I also don't know how to do).