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 )

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

On 12 Jan., 00:29, yguan wrote:
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 )

you can also use subtotals and get the required data without using a formula
--
Thanks
Suleman Peerzade


"yguan" wrote:

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 )