# Sum Unique Values Excel 2010

#### Orestes543

##### New Member
Hello All,

I believe this is my first post, although I've received a ton of help by reading the forums. To my question: I have a list of invoices (unique number), a list of Vendor ID's (duplicates), and a list of Check numbers (duplicates, and containing multiple invoice numbers). All I am wanting to do is sum the check number one time, the first time it is found. I have been sniffing around posts here all day almost finding enough information to put this together, but I can't get my head around it. I know this will somehow involve Frequency, Match, Row, Sum, If, etc, but I'm not able to get it structured having never used array formulas. I'm sure for the vets this will take maybe a full second to figure out. I hope my post is in proper format .

Thanks a bunch

 Excel 2010 A B C D E F G H 1 Vendor ID Invoice Number Invoice Amount Check Number Check Amount Issued Amount Total Result I'd like to see in F 2 1 1001 \$50.00 200001 \$125.00 \$125.00 3 1 1002 \$75.00 200001 \$125.00 Skips 4 2 1003 \$60.00 200002 \$145.00 \$145.00 5 2 1004 \$85.00 200002 \$145.00 Skips 6 3 1005 \$70.00 200003 \$165.00 \$165.00 7 3 1006 \$95.00 200003 \$165.00 Skips 8 4 1007 \$80.00 200004 \$185.00 \$185.00 9 4 1008 \$105.00 200004 \$185.00 Skips 10 5 1009 \$90.00 200005 \$215.00 \$215.00 11 5 1010 \$125.00 200005 \$215.00 12 Total: \$835.00 \$835.00 Total Sheet1

<tbody>
</tbody>

### Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
F2, copied down:

=IF(ISNUMBER(MATCH(\$A2,\$A\$1:A1,0)),"",\$E2)

Replies
3
Views
208
Replies
2
Views
510
Replies
4
Views
186
Replies
7
Views
464
Replies
9
Views
398

1,202,908
Messages
6,052,488
Members
444,587
Latest member
ezza59

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back