Help with collecting data from a spreadsheet

J

JChan

Hi All,

I am hoping someone will be able to help me out here;

I currently have a spreadsheet containing stock that has been sold over
the last year. Column A contains the stock code number, Column B
contains a description of the stock and Column C is the quantity of
stock sold for each transation.

For Example,

Column A Column B Column C
001 Pencil
1
001 Pencil
5
001 Pencil
2
002 Eraser
3
002 Eraser
1
003 Ruler
1
004 Glue Stick
2
004 Glue Stick
1
004 Glue Stick
1
004 Glue Stick
3


I need to add up the quantity of each product sold to get a rough
estimate of how much stock we sold over the last year, (eg, Pencil = 8;
Eraser = 4; Ruler = 1; Glue Stick = 7). At the moment I am scrolling
thru the spreadsheet and autosumming each product to get the total
quantity sold.

Is there a way I can get excel to:
1. at the end of the spreadsheet list each product code & description
2. calculate the total quantities of each product sold?

I dont know if this is possible, but if anyone can help me or has any
suggestions that would be most appreciated.

Kind Regards

Justin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Combination 1
To find rate of each item from item.xls and to copy price.xls 7
Combining two spreadsheets. 5
Add up a value that meets 2 criteria 5
Count occurances in data 2
Creating a new table from another - filtering out unwanted data 8
Combining same data in multiple rows 4
HELP! Find Data in columns next to known data then Calculate 2

Top