I have the following data inculded Customer, Invoice no., Part no and Qty.
In Invoice, there will be same part no., How can show the same part no. in
one and the qty will be sum.

Use marco or function...............any better methods????


e.g
customer Invoice no. Part no. Qty.
KATATA HK0811-0001 RK73H2ATTD 102F / 50000
KATATA HK0811-0001 RK73H2ATTD 102F / 40000
KATATA HK0811-0001 RK73B1JTTD 204J / 30000
KATATA HK0811-0001 RK73B1JTTD 204J / 5000

(I want the following result:)

KATATA HK0811-0001 RK73H2ATTD 102F / 90000
KATATA HK0811-0001 RK73B1JTTD 204J / 35000

Assume you have data in Col A - Customer
Col B - Invoice no.
Col C - Part no.
Col D - Qty.

Go to Data | filter | advance filter | action: copy to another
location | list range: A1:C5 | copy to: F1 | check unique records only
| ok |

You will find data like this
Customer Invoice no. Part no.
KATATA HK0811-0001 RK73H2ATTD 102F /
KATATA HK0811-0001 RK73B1JTTD 204J /

Now in cell I2 put this formula

=SUMIF($C$2:$C$5,H2,$D$2:$D$5) and drag it down




On Nov 16, 12:49*pm, Wu wrote:
I have the following data inculded Customer, Invoice no., Part no and Qty..
In Invoice, there will be same part no., How can show the same part no. in
one and the qty will be sum.

Use marco or function...............any better methods????

e.g
customer * *Invoice no. * * * * * * * *Part no. * * * * * * * * * * Qty.
KATATA *HK0811-0001 * * RK73H2ATTD 102F / * * * 50000
KATATA *HK0811-0001 * * RK73H2ATTD 102F / * * * 40000
KATATA *HK0811-0001 * * RK73B1JTTD 204J / * * * 30000
KATATA *HK0811-0001 * * RK73B1JTTD 204J / * * * 5000

(I want the following result:)

KATATA *HK0811-0001 * * RK73H2ATTD 102F / * * * 90000
KATATA *HK0811-0001 * * RK73B1JTTD 204J / * * * 35000