Browse » Home
Sunday, July 24, 2011
How to Summarize Data in Excel
1. Use the Subtotals method. Choose one customer name by selecting a cell in column A. Click the 'AZ' sort button--you can find this on the standard toolbar. Next, select 'Data' and then 'Subtotals.' The Subtotals dialog box should appear. Make sure you've checked off 'OldSales,' 'NewSales' and 'Total.' Click 'OK' to see the summary data in bold on your spreadsheet. Press the '2' in the top left corner of your spreadsheet to see only the summary data.
2. Try the Consolidate method. Select a blank cell to the right of your data. Click 'Data' and 'Consolidate.' In the 'Reference' section in the 'Consolidate' dialog box, select your entire table and click 'OK'. This produces a new row with summarized totals for each unique customer in Column A. Delete the 'Date' field in the summary results.
3. Create a Pivot Table. Select a blank cell to the right of your data. Click 'Data' and 'Pivot Table and PivotChart Report.' Select your entire data table and click 'Finish.' Choose to add 'Customer' and 'Total' to the new pivot table. Excel sorts the summarized data by unique customer.