Sum one's column cells when others columns cells match

[ChrisDev]

[FONT=&quot]I have the an excell sheet like the following example:

column ABCD

[/FONT] <table class="MsoNormalTable" style="width: 404pt; border-collapse: collapse;" width="539" border="0" cellpadding="0" cellspacing="0"> <tbody><tr style="height: 12.75pt;"> <td style="padding: 0cm; width: 56pt; height: 12.75pt;" width="75"> [FONT=&quot]1.023-101.0<o></o>[/FONT]
</td> <td style="padding: 0cm; width: 170pt; height: 12.75pt;" width="227"> [FONT=&quot] CV 30/1 *EU<o></o>[/FONT]
</td> <td style="padding: 0cm; width: 48pt; height: 12.75pt;" width="64">

[FONT=&quot]60<o></o>[/FONT]​

</td> <td style="padding: 0cm; width: 82pt; height: 12.75pt;" width="109">

[FONT=&quot]7<o></o>[/FONT]​

</td> <td style="padding: 0cm; width: 48pt; height: 12.75pt;" width="64"></td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0cm; height: 12.75pt;"> [FONT=&quot]1.024-104.0<o></o>[/FONT]
</td> <td style="padding: 0cm; height: 12.75pt;"> [FONT=&quot]WTC 600 CD *EU<o></o>[/FONT]
</td> <td style="padding: 0cm; height: 12.75pt;">

[FONT=&quot]2001<o></o>[/FONT]​

</td> <td style="padding: 0cm; height: 12.75pt;">

[FONT=&quot]5<o></o>[/FONT]​

</td> <td style="padding: 0cm; height: 12.75pt;"></td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0cm; height: 12.75pt;"> [FONT=&quot]1.024-116.0<o></o>[/FONT]
</td> <td style="padding: 0cm; height: 12.75pt;"> [FONT=&quot]WPC 100 CD<o></o>[/FONT]
</td> <td style="padding: 0cm; height: 12.75pt;">

[FONT=&quot]60<o></o>[/FONT]​

</td> <td style="padding: 0cm; height: 12.75pt;">

[FONT=&quot]1<o></o>[/FONT]​

</td> <td style="padding: 0cm; height: 12.75pt;"></td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0cm; height: 12.75pt;"> [FONT=&quot]1.024-205.0<o></o>[/FONT]
</td> <td style="padding: 0cm; height: 12.75pt;"> [FONT=&quot]WPC 100 FW-A<o></o>[/FONT]
</td> <td style="padding: 0cm; height: 12.75pt;">

[FONT=&quot]60<o></o>[/FONT]​

</td> <td style="padding: 0cm; height: 12.75pt;">

[FONT=&quot]1<o></o>[/FONT]​

</td> <td style="padding: 0cm; height: 12.75pt;"></td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0cm; height: 12.75pt;"> [FONT=&quot]1.024-205.0<o></o>[/FONT]
</td> <td style="padding: 0cm; height: 12.75pt;"> [FONT=&quot]WPC 100 FW-A<o></o>[/FONT]
</td> <td style="padding: 0cm; height: 12.75pt;">

[FONT=&quot]2001<o></o>[/FONT]​

</td> <td style="padding: 0cm; height: 12.75pt;">

[FONT=&quot]1<o></o>[/FONT]​

</td> <td style="padding: 0cm; height: 12.75pt;"></td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0cm; height: 12.75pt;"> [FONT=&quot]1.024-212.0<o></o>[/FONT]
</td> <td style="padding: 0cm; height: 12.75pt;"> [FONT=&quot] WPC 600 MP-AM<o></o>[/FONT]
</td> <td style="padding: 0cm; height: 12.75pt;">

[FONT=&quot]2001<o></o>[/FONT]​

</td> <td style="padding: 0cm; height: 12.75pt;">

[FONT=&quot]1<o></o>[/FONT]​

</td> <td style="padding: 0cm; height: 12.75pt;"></td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0cm; height: 12.75pt;"> [FONT=&quot]1.024-212.0<o></o>[/FONT]
</td> <td style="padding: 0cm; height: 12.75pt;"> [FONT=&quot]WTC 600 MP-AM<o></o>[/FONT]
</td> <td style="padding: 0cm; height: 12.75pt;">

[FONT=&quot]2001<o></o>[/FONT]​

</td> <td style="padding: 0cm; height: 12.75pt;">

[FONT=&quot]1<o></o>[/FONT]​

</td> <td style="padding: 0cm; height: 12.75pt;"></td> </tr> </tbody></table> [FONT=&quot]
There are totally about 800 rows like them. As you can see some cells in the first column match. So i need somehow for every matching cell in column A to sumthe column D. Maybe it's unachievable that i'm asking.
[/FONT][FONT=&quot]Thank you for your help. I appreciate.[/FONT]

 

[Oaktree]

Welcome to the board.

For one specific value in column A, have a look at the SUMIF function in Excel help.

To sum by *every* value in column A, consider using a pivot table.