Dear Professionals
I have a data sheet of goods codes. I want to find and sum all specific goods code of a company and put it in another sheet. I tried many functions.But i didnt get the right result.
Please help, thank you.
Data Sheet of goods codes ( in sheet 1)
[TABLE="width: 385"]
<tbody>[TR]
[TD="align: left"][TABLE="width: 385"]
<tbody>[TR]
[TD="align: left"]Company Name[/TD]
[TD="align: left"]Goods Code[/TD]
[TD="align: left"] Value[/TD]
[/TR]
[TR]
[TD="align: left"]Name A[/TD]
[TD][/TD]
[TD] 99.107.985[/TD]
[/TR]
[TR]
[TD="align: left"]Name A[/TD]
[TD="align: left"]1001[/TD]
[TD] 58.477.131[/TD]
[/TR]
[TR]
[TD="align: left"]Name A[/TD]
[TD="align: left"]1001[/TD]
[TD] 58.477.131[/TD]
[/TR]
[TR]
[TD="align: left"]Name A[/TD]
[TD="align: left"]1001[/TD]
[TD] (58.477.131)[/TD]
[/TR]
[TR]
[TD="align: left"]Name A[/TD]
[TD="align: left"]1701[/TD]
[TD] 13.568.312[/TD]
[/TR]
[TR]
[TD="align: left"]Name A[/TD]
[TD="align: left"]1701[/TD]
[TD] 19.867.089[/TD]
[/TR]
[TR]
[TD="align: left"]Name A[/TD]
[TD="align: left"]1701[/TD]
[TD] 6.195.453[/TD]
[/TR]
[TR]
[TD="align: left"]Name A[/TD]
[TD="align: left"]1701[/TD]
[TD] 19.867.089[/TD]
[/TR]
[TR]
[TD="align: left"]Name A[/TD]
[TD="align: left"]1701[/TD]
[TD] (19.867.089)[/TD]
[/TR]
[TR]
[TD="align: left"]Name A[/TD]
[TD="align: left"]1804[/TD]
[TD] 1.000.000[/TD]
[/TR]
[TR]
[TD="align: left"]Name A[/TD]
[TD="align: left"]1804[/TD]
[TD] 1.000.000[/TD]
[/TR]
[TR]
[TD="align: left"]Name A[/TD]
[TD="align: left"]1804[/TD]
[TD] (1.000.000)[/TD]
[/TR]
[TR]
[TD="align: left"]Name A[/TD]
[TD="align: left"]1849[/TD]
[TD] 1.000.000[/TD]
[/TR]
[TR]
[TD="align: left"]Name A[/TD]
[TD="align: left"]1849[/TD]
[TD] (1.000.000)[/TD]
[/TR]
[TR]
[TD="align: left"]Name B[/TD]
[TD][/TD]
[TD] 2.913.437.062[/TD]
[/TR]
[TR]
[TD="align: left"]Name B[/TD]
[TD="align: left"]1552[/TD]
[TD] 213.649.800[/TD]
[/TR]
[TR]
[TD="align: left"]Name B[/TD]
[TD="align: left"]1552[/TD]
[TD] 120.000.474[/TD]
[/TR]
[TR]
[TD="align: left"]Name B[/TD]
[TD="align: left"]1552[/TD]
[TD] 179.999.526[/TD]
[/TR]
[TR]
[TD="align: left"]Name B[/TD]
[TD="align: left"]1552[/TD]
[TD] 142.434.137[/TD]
[/TR]
[TR]
[TD="align: left"]Name B[/TD]
[TD="align: left"]1701[/TD]
[TD] 250.000.000[/TD]
[/TR]
[TR]
[TD="align: left"]Name B[/TD]
[TD="align: left"]1701[/TD]
[TD] 250.000.000[/TD]
[/TR]
[TR]
[TD="align: left"]Name B[/TD]
[TD="align: left"]1701[/TD]
[TD] (240.000.000)[/TD]
[/TR]
[TR]
[TD="align: left"]Name B[/TD]
[TD="align: left"]1701[/TD]
[TD] (760.000.000)[/TD]
[/TR]
[TR]
[TD="align: left"]Name B[/TD]
[TD="align: left"]1701[/TD]
[TD] 750.000.000[/TD]
[/TR]
[TR]
[TD="align: left"]Name B[/TD]
[TD="align: left"]1701[/TD]
[TD] 760.000.000[/TD]
[/TR]
[TR]
[TD="align: left"]Name B[/TD]
[TD="align: left"]1701[/TD]
[TD] 240.000.000[/TD]
[/TR]
[TR]
[TD="align: left"]Name B[/TD]
[TD="align: left"]1701[/TD]
[TD] 750.000.000[/TD]
[/TR]
[TR]
[TD="align: left"]Name B[/TD]
[TD="align: left"]4911[/TD]
[TD] 191.576.762[/TD]
[/TR]
[TR]
[TD="align: left"]Name B[/TD]
[TD="align: left"]4911[/TD]
[TD] 65.776.363[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[/TR]
</tbody>[/TABLE]
How to automatically find goods code 1552 of Name B and put the sum in the table below ( in Sheet 2)
[TABLE="width: 384"]
<tbody>[TR]
[TD] [TABLE="width: 384"]
<tbody>[TR]
[TD]Company Name[/TD]
[TD="colspan: 4"] Goods Code[/TD]
[/TR]
[TR]
[/TR]
[TR]
[TD]1001[/TD]
[TD]1701[/TD]
[TD]1552[/TD]
[TD]1804[/TD]
[/TR]
[TR]
[TD="align: left"]Name A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: left"]Name B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: left"]Name C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]…………[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="colspan: 4"][/TD]
[/TR]
</tbody>[/TABLE]
I have an excel file but i cant upload to explain my problem clearly.
Thank you Professionals. looking forward to hearing from you.
Best regards
I have a data sheet of goods codes. I want to find and sum all specific goods code of a company and put it in another sheet. I tried many functions.But i didnt get the right result.
Please help, thank you.
Data Sheet of goods codes ( in sheet 1)
[TABLE="width: 385"]
<tbody>[TR]
[TD="align: left"][TABLE="width: 385"]
<tbody>[TR]
[TD="align: left"]Company Name[/TD]
[TD="align: left"]Goods Code[/TD]
[TD="align: left"] Value[/TD]
[/TR]
[TR]
[TD="align: left"]Name A[/TD]
[TD][/TD]
[TD] 99.107.985[/TD]
[/TR]
[TR]
[TD="align: left"]Name A[/TD]
[TD="align: left"]1001[/TD]
[TD] 58.477.131[/TD]
[/TR]
[TR]
[TD="align: left"]Name A[/TD]
[TD="align: left"]1001[/TD]
[TD] 58.477.131[/TD]
[/TR]
[TR]
[TD="align: left"]Name A[/TD]
[TD="align: left"]1001[/TD]
[TD] (58.477.131)[/TD]
[/TR]
[TR]
[TD="align: left"]Name A[/TD]
[TD="align: left"]1701[/TD]
[TD] 13.568.312[/TD]
[/TR]
[TR]
[TD="align: left"]Name A[/TD]
[TD="align: left"]1701[/TD]
[TD] 19.867.089[/TD]
[/TR]
[TR]
[TD="align: left"]Name A[/TD]
[TD="align: left"]1701[/TD]
[TD] 6.195.453[/TD]
[/TR]
[TR]
[TD="align: left"]Name A[/TD]
[TD="align: left"]1701[/TD]
[TD] 19.867.089[/TD]
[/TR]
[TR]
[TD="align: left"]Name A[/TD]
[TD="align: left"]1701[/TD]
[TD] (19.867.089)[/TD]
[/TR]
[TR]
[TD="align: left"]Name A[/TD]
[TD="align: left"]1804[/TD]
[TD] 1.000.000[/TD]
[/TR]
[TR]
[TD="align: left"]Name A[/TD]
[TD="align: left"]1804[/TD]
[TD] 1.000.000[/TD]
[/TR]
[TR]
[TD="align: left"]Name A[/TD]
[TD="align: left"]1804[/TD]
[TD] (1.000.000)[/TD]
[/TR]
[TR]
[TD="align: left"]Name A[/TD]
[TD="align: left"]1849[/TD]
[TD] 1.000.000[/TD]
[/TR]
[TR]
[TD="align: left"]Name A[/TD]
[TD="align: left"]1849[/TD]
[TD] (1.000.000)[/TD]
[/TR]
[TR]
[TD="align: left"]Name B[/TD]
[TD][/TD]
[TD] 2.913.437.062[/TD]
[/TR]
[TR]
[TD="align: left"]Name B[/TD]
[TD="align: left"]1552[/TD]
[TD] 213.649.800[/TD]
[/TR]
[TR]
[TD="align: left"]Name B[/TD]
[TD="align: left"]1552[/TD]
[TD] 120.000.474[/TD]
[/TR]
[TR]
[TD="align: left"]Name B[/TD]
[TD="align: left"]1552[/TD]
[TD] 179.999.526[/TD]
[/TR]
[TR]
[TD="align: left"]Name B[/TD]
[TD="align: left"]1552[/TD]
[TD] 142.434.137[/TD]
[/TR]
[TR]
[TD="align: left"]Name B[/TD]
[TD="align: left"]1701[/TD]
[TD] 250.000.000[/TD]
[/TR]
[TR]
[TD="align: left"]Name B[/TD]
[TD="align: left"]1701[/TD]
[TD] 250.000.000[/TD]
[/TR]
[TR]
[TD="align: left"]Name B[/TD]
[TD="align: left"]1701[/TD]
[TD] (240.000.000)[/TD]
[/TR]
[TR]
[TD="align: left"]Name B[/TD]
[TD="align: left"]1701[/TD]
[TD] (760.000.000)[/TD]
[/TR]
[TR]
[TD="align: left"]Name B[/TD]
[TD="align: left"]1701[/TD]
[TD] 750.000.000[/TD]
[/TR]
[TR]
[TD="align: left"]Name B[/TD]
[TD="align: left"]1701[/TD]
[TD] 760.000.000[/TD]
[/TR]
[TR]
[TD="align: left"]Name B[/TD]
[TD="align: left"]1701[/TD]
[TD] 240.000.000[/TD]
[/TR]
[TR]
[TD="align: left"]Name B[/TD]
[TD="align: left"]1701[/TD]
[TD] 750.000.000[/TD]
[/TR]
[TR]
[TD="align: left"]Name B[/TD]
[TD="align: left"]4911[/TD]
[TD] 191.576.762[/TD]
[/TR]
[TR]
[TD="align: left"]Name B[/TD]
[TD="align: left"]4911[/TD]
[TD] 65.776.363[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[/TR]
</tbody>[/TABLE]
How to automatically find goods code 1552 of Name B and put the sum in the table below ( in Sheet 2)
[TABLE="width: 384"]
<tbody>[TR]
[TD] [TABLE="width: 384"]
<tbody>[TR]
[TD]Company Name[/TD]
[TD="colspan: 4"] Goods Code[/TD]
[/TR]
[TR]
[/TR]
[TR]
[TD]1001[/TD]
[TD]1701[/TD]
[TD]1552[/TD]
[TD]1804[/TD]
[/TR]
[TR]
[TD="align: left"]Name A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: left"]Name B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: left"]Name C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]…………[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="colspan: 4"][/TD]
[/TR]
</tbody>[/TABLE]
I have an excel file but i cant upload to explain my problem clearly.
Thank you Professionals. looking forward to hearing from you.
Best regards