It sounds like you want a report in Excel. Have you tried PROC PRINT with the SUM statement???
Do you know which technique you're going to use to get your output into Excel??? You basically have 3 choices using ODS:
1) creating a comma-separated file using ODS CSV or ODS CSVALL
2) creating an HTML file using ODS HTML, ODS HTML3 or ODS MSOFFICE2K
3) creating an XML file that follows the Microsoft Spreadsheet Markup Language XML specification for how to describe a workbook and worksheets using ODS TAGSETS.EXCELXP
Some examples of using each of these 3 techniques is shown in an answer to your previous posting.
As to what procedure you use, I suggest you try a PROC PRINT something like this (code not tested because there's not enough information about your destination to generate working ODS code).
proc print data=lib.yourdata;
var col1 col2;
Consider the opportunity to have a separate XLS document containing only a pivot-table report (your summary information), and the XLS documents opens and imports an external CSV file. You can then keep your SAS-exported data separate from the Excel document that does the summarization and report generation, if that is your reference. For your SAS execution, you would want to explore using PROC EXPORT directly to a CSV-format (or XLS directly).