lookup table with multiple variables

[mcurts]

I would appreciate if someone could help me on this matter.

I am trying to perform a lookup in the table below:

Code EE ID # Service Type Quantity
7 BECT01 RS 7.5
7 BECT01 SSWL 2
7 ZAPA01 SSWL 2
9 HADL01 SRT 2

I want to pull information into another worksheet giving me the sum of the quantities by Code and By Service Type. I want it to pull this information automatically.

Does anyone understand what I am trying to get at with my question? If I need to be more specific please let me know.

Thank you for your time.

 

[fairwinds]

Hi,

Is this what you want?

Book1
	A	B	C	D	E	F	G	H
1	Code	ID	Type	Qty		Code	Type	Totqty
2	7	BECT01	RS	7.5		7	SSWL	4
3	7	BECT01	SSWL	2		7	RS	7.5
4	7	ZAPA01	SSWL	2
5	9	HADL01	SRT	2
6
Sheet3