calculating multipul amounts under same heading

[hellyg]

hi i am using excell 2008 for mac, I am imputing data into a chart where I have product sku's then number of items recieved on a specific date. I then have a long list of sku's and amounts. Is there a way excell can add up all the amounts or the same sku numbers??

SKU Code Decription Quantity
AP001 BROUCH SML 10
AP001 BROUCH SML -8
AP003 HEADBAND/ CLIP 1
AP003 HEADBAND/ CLIP -1
AP004 PURSE 3
AP004 PURSE -2
AP005 HAIRCLIP 1
AP005 HAIRCLIP -1

For example is there a way to create a formula that add all the quantities on a row with same sku. eg (AP001=10-8)=2

Regards, helen

 

[asad]

Try something like this,

Excel Workbook
	A	B	C
1	SKU	Code Decription	Quantity
2	AP001	BROUCH SML	10
3	AP001	BROUCH SML	-8
4	AP003	HEADBAND/ CLIP	1
5	AP003	HEADBAND/ CLIP	-1
6	AP004	PURSE	3
7	AP004	PURSE	2
8	AP005	HAIRCLIP	1
9	AP005	HAIRCLIP	-1
10
11
12
13	AP001		2
Sheet1

 

[hellyg]

Thats Great.. been up all night trying to figure that out.. cheers.