To all the Problem solvers out there:
I have a data set that provides a total number of contributions broken down by zip code for a certain month e.g. total contributions in Zip Code 10001 in August might be $400, while 10002 is $0 etc…
I would like to determine the sum of these contributions by State. My zip code layer contains a field that identifies the State that the zip code is located in, so I can easily use the Select by Attributes builder and the Statistics function within the Attribute table to create a selection and then determine the total for each state, however, I’m sure there must be a smarter way then having to perform the same set of operations 50 times over (Using Model Builder perhaps?).
I’d appreciate any advice on how to achieve this, there may be a specific tool in the ArcToolBox that do exactly what I need which I am overlooking.