Tip Printed from ExcelTip.com

---

Summing Stock Lists


To total stock List quantities:

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.
Result:

Oops!!! The Price per Unit (see cells C17:C23 in the screenshot) has also been totaled!!!

Solution:

1. For each List, change the heading above the Price per unit column to Price per Unit L1 in cell C1 and Price per Unit L2 in cell C8 (see screenshot).
2. Repeat steps 2 through 6 on the previous page to consolidate the Lists.