I have an automatic job scheduled daily to run and extract data from a database and emails the data in an excel attachement to a list of users.

Is there anyway to automatically provide summary data for some columns? I can do it manually using the AutoSum formula but program/process that I am using does not allow for any data manipulation. It just extracts the requested data and outputs into an email excel attachment, allowing (and assuming) the user to manipulate the data themselves.

Now I am being told users do now want/do not know how to summarize the data themselves. They want it handed to them. When they get the excel attachment in the email, it should already be summarized.

What can I do to solve this problem ?