Count of unique sub-entries

[leebauman]

I need to count unique entries. Objective is to sum invoice counts per project in a pivot. Sample below. Thank you.

Book3
	A	B	C
1	Project	Invoice	Unique Invoice Count
2	AAA	111	1
3	AAA	111
4	AAA	111
5	AAA	222	1
6	AAA	111
7	AAA	333	1
8	AAA	222
9	AAA	111
10	AAA	444	1
11	BBB	555	1
12	BBB	555
13	BBB	666	1
Sheet1

 

[dreid1011]

Perhaps this:

Book1
	A	B	C	D
1	Project	Invoice	Unique Invoice Count
2	AAA	111	1	1
3	AAA	111
4	AAA	111
5	AAA	222	1	1
6	AAA	111
7	AAA	333	1	1
8	AAA	222
9	AAA	111
10	AAA	444	1	1
11	BBB	555	1	1
12	BBB	555
13	BBB	666	1	1
Sheet4

Cell Formulas
Range	Formula
D2:D13	D2	=LET(c,COUNTIFS($A$2:A2,A2,$B$2:B2,B2),IF(c=1,c,""))

 

[leebauman]

That works perfectly. Thank you!

 

[dreid1011]

That works perfectly. Thank you!

You're welcome, and happy to help.