I'm using excel 2003 and i need help about the function or formula on my
monthly sale breakdown. I have 3 client table in a same sheet.Where show
date,item,code and weight.I need to count total of weight where all same item
and date in a different table.

Example

Client A
Date Code Item Weight(KG)
1/2 xxxx PA 1000
2/2 xxxx PH 1300
3/2 xxxx PA 2300
4/2 xxxx PA 4300

Client B
Date Code Item Weight(KG)
1/2 xxxx PH 1600
2/2 xxxx PH 1000
5/2 xxxx PA 2800
7/2 xxxx PH 1000

Client C
Date Code Item Weight(KG)
1/2 xxxx PA 4000
2/2 xxxx PH 7300
3/2 xxxx PA 8300
6/2 xxxx PH 4300

Example what i need

Date Item Weight(KG)
1/2 PA ????
2/2 PA ????
3/2 PA ????
4/2 PA ????
--------------------------------
Total ????