Function or formula to use

[yguan]

Can someone help me again …. I try the function but is not work…..and maybe I
should draw it clearly . I'm using excel 2003 and i need help about the
function or formula on my monthly sale breakdown. I have 3 or more client
table in a same sheet. Where show date, code, item and weight. I need to
count total of weight by daily from all 3 client table for same item.

Example

Client A
Date Code Item Weight(KG)
1 Jan xxxx PA 10
1 Jan xxxx PH 20
2 Jan xxxx PH 13
2 Jan xxxx PA 10
3 Jan xxxx PA 23
4 Jan xxxx PA 43

Client B
Date Code Item Weight(KG)
1 Jan xxxx PH 10
1 Jan xxxx PA 10
2 Jan xxxx PH 13
3 Jan xxxx PA 15
4 Jan xxxx PH 10
4 Jan xxxx PA 10

Client C
Date Code Item Weight(KG)
1 Jan xxxx PA 10
2 Jan xxxx PH 13
2 Jan xxxx PA 10
3 Jan xxxx PA 50
4 Jan xxxx PH 43

What i need is like below

Date Item Weight(KG)
1 Jan PA 30 ( the result is sum from above client table
where item =PA )
2 Jan PA 10
3 Jan PA 88
4 Jan PA ?

( result for 1 Jan = Client A,B & C ( 10+10+10 = 30 )

( so what formula or function to sum all item PA for 4 Jan from above client
table )

 

[Per Jessen]

Hi

Always continue in the original thread.

You say that the formulas we suggested don't work - it's the only kind
of formula that will work for you.

What is wrong about the formulas? Isn't all clients in columns A-D
below each other. Is the resulting table in other rows ? (which)

Have you tried to adjust the formula without any luck, then post your
formula.

Hopes it helps.

Regards,
Per

 

[Suleman Peerzade]

you can also use subtotals and get the required data without using a formula