Total duplicates formula

Drbarber

New Member
Joined
Oct 8, 2008
Messages
2
I need help building a formula to total each person's amounts in a separate column when they're duplicated. ex:

<table x:str="" style="border-collapse: collapse; width: 227pt;" width="303" border="0" cellpadding="0" cellspacing="0"><col style="width: 71pt;" width="95"> <col style="width: 48pt;" width="64"> <col style="width: 108pt;" width="144"> <tbody><tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt; width: 71pt;" width="95" height="17">SSN</td> <td style="width: 48pt;" width="64">AMT</td> <td style="width: 108pt;" width="144">TOTAL AMT</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">387781101</td> <td x:num="" align="right">25</td> <td x:num="" align="right">25</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">387783945</td> <td x:num="" align="right">75</td> <td x:num="" align="right">75</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">387843713</td> <td x:num="" align="right">150</td> <td x:num="" align="right">150</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="background: rgb(255, 255, 153) none repeat scroll 0% 0%; height: 12.75pt; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="" align="right" height="17">387862646</td> <td x:num="" align="right">100</td> <td x:num="" align="right">177</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="background: rgb(255, 255, 153) none repeat scroll 0% 0%; height: 12.75pt; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="" align="right" height="17">387862646</td> <td x:num="" align="right">77</td> <td x:num="" align="right">177</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="background: rgb(255, 255, 153) none repeat scroll 0% 0%; height: 12.75pt; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="" align="right" height="17">387868771</td> <td x:num="" align="right">25</td> <td x:num="" align="right">181</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="background: rgb(255, 255, 153) none repeat scroll 0% 0%; height: 12.75pt; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="" align="right" height="17">387868771</td> <td x:num="" align="right">100</td> <td x:num="" align="right">181</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="background: rgb(255, 255, 153) none repeat scroll 0% 0%; height: 12.75pt; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="" align="right" height="17">387868771</td> <td x:num="" align="right">56</td> <td x:num="" align="right">181</td> </tr> </tbody></table>

Sometimes there will be as many as 5 or 6 duplicate values, sometimes none....

Any help is greatly appreciated.

-DRBARBER
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,824
Office Version
365
Platform
Windows
Try using the SUMIF function, where you are summing all the Amt values from your entire column that match the SSN on that row.

See Excel's help on the SUMIF function for examples and explanations.
 

Forum statistics

Threads
1,085,986
Messages
5,387,112
Members
402,042
Latest member
snowballresource02

Some videos you may like

This Week's Hot Topics

Top