How to sum columns from multiple excel workbooks?

Question

I have 4 workbooks all with the same formatting. I am trying to combine these into one workbook that sums all the cells with the same account ID and column position. I've seen people use transpose and crosstab but I was wondering if I could just use the Sum tool? Whenever I try this, however, the sum totals don't tie to the check figures I have.

JosephSerpis · Answer

Hi @sarahbritt if you utlise one of the techninque in this article to combine your 4 files then you should be able to use the Summarize tool. However without seeing your workflow or data I wouldn't be able to comment on why they don't tie to the checks. However the approach you describe is sensible and is something a Alteryx user could and would do.