Best way to make a summary sheet for an excel file?

[abragg0103]

So I have a simple workflow that takes in a ton of data, filters and processes it, then outputs it. Perfect. But then i still have to open it and do my own sum function to find what I need. There are a ton of rows with varying values in the Quantity field. I want to know the sum of all quantities less than or equal 1 million, and I also want to know the sum of all quantities greater than 1 million.

I get a massive file every day that I run through this workflow, is there a good way to have a summary sheet that just tells me this so I dont have to sum them manually?

[Aaron_Harter · Accepted solution]

Hi @abragg0103,

You may want to use the Summarize tool to create an exception report and use this new data stream to create a summary file: