Tip Printed from ExcelTip.com

---

Summing Sales Quantities and Amounts for Several Lists, or Presenting the Figures Side-by-Side


To total the quantities and the amounts of monthly sales Lists:

1. Define Names for two Lists, and note the instructions on how to consolidate Lists,
2. Select a cell, and from the Data menu, select Consolidate.
3. In the Reference box, press F3.
4. In the Paste Name dialog box, select List1, click OK, and then click Add to add List1 to All references.
5. Press F3 again and add List2 to All references.
6. In Use Labels in, select the Top row and Left column checkboxes, and then click OK.

To display total sales (quantity and amounts) by month, side-by-side:

1. In List1, change the heading titles Quantities and Total Sales to Quantity – Jan and Total Sales – Jan, respectively.
2. In List2, change the heading titles Quantity and Total Sales to Quantity – Feb and Total Sales – Feb, respectively.
3. Repeat steps 2 through 6 on the previous page to consolidate the Lists.