skus in columm a for each sale, qty. of skus sold, each sale in co

skus in columm a for each sale, qty. of skus sold, each sale in co

Post by Y29uZnVzZW » Mon, 13 Jun 2005 05:29:03


I have the sku *part number for each individual item for each sale in column
A. In column B, I have the Qty. sold of each individual sku per order. I want
to be able to total the qty. sold of each sku. As an example 1rst sku in
column A is 41-402*Column A list the sku sold for the sale, column B lists
the Qty. of that sku sold for that individual sale. There are several hundred
sales in column a and the same sku will appear several times with different
qtys. listed in column b. Need to sort and total Qty. of each sku sold .
--
confused1
 
 
 

skus in columm a for each sale, qty. of skus sold, each sale in co

Post by Sk1C » Mon, 13 Jun 2005 05:44:04

First select/hightlight your table (column A and Column B through however
many rows you have). Click Data/Sort. Select SKU from the combo box for the
primary key. Click OK. Your table should be sorted by SKU number.

Then Click Data/Subtotals. Select

At Each Change In: SKU
Use Function : Sum
Add Subtotal To: Quantity (whatever header represents your quantity column)

Now using the + - buttons (or the columns buttons that appear above these)
that will appear to the left of your spreadsheet, you can expand/collapse
your summary to display however you want.