Is it possible to sum all existing fields without using summarize tool?

Question

Hi,

I'm trying to sum all the data in every existing columns. However, the summarize tool will need to predefine the field header. What if my input data will change every time (meaning instead of having 5 columns, i might have 6 columns next time). So instead of going back to add the new column in the summarize tool, is there a way to just sum all existing fields?

Please let me know if you would like an example?

Thank you for all of your help in advance.

Thanks,

estherb47 · Accepted Answer

Hi @calvinwong

You can use the Transpose tool to get all of the columns into one column, and then a Summarize tool that just adds up all of the values in the new column.

Cheers!

Esther