Sum Unique Values Excel 2010

[Orestes543]

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>

 

[Aladin Akyurek]

F2, copied down:

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