Function or formula to use

Y

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 )
 
P

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
 
S

Suleman Peerzade

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top