I can't figure out the count. Thank you, if you can help.

[bgurtz]

I have cells A1 with dates such as 1/2/18
I have cell B1 with names (some are duplicate)
I am trying to figure out away to count how many (unique) names worked on per day of the month.
I can not figure out how to do this. I have tried using the .. =SUMPRODUCT(1/COUNTIF(A1:A22,A1:A22))
I can get the unique value for a people, but i can not get it to do the dates,

Any help would be great. Thank you.

[TABLE="width: 500"]
<tbody>[TR]
[TD]1/5/2018[/TD]
[TD]Mike[/TD]
[TD]............[/TD]
[/TR]
[TR]
[TD]1/5/2018[/TD]
[TD]Mike[/TD]
[TD]Example:[/TD]
[/TR]
[TR]
[TD]1/5/2018[/TD]
[TD]Chris[/TD]
[TD]1/5/2018 .. 4 people worlked[/TD]
[/TR]
[TR]
[TD]1/5/2018[/TD]
[TD]Frank[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/5/2018[/TD]
[TD]Chase[/TD]
[TD]1/7/2018 .. 2 people worked[/TD]
[/TR]
[TR]
[TD]1/7/2018[/TD]
[TD]Kian[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/7/2018[/TD]
[TD]Corey[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/7/2018[/TD]
[TD]Corey[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/10/2018[/TD]
[TD]Frank[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/10/2018[/TD]
[TD]Mark[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/14/2018[/TD]
[TD]Frank[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/22/2018[/TD]
[TD]Knox[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/22/2018[/TD]
[TD]Kian[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/22/2018[/TD]
[TD]Mike[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/22/2018[/TD]
[TD]Mike[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[AhoyNC]

Try:
This is an array formula and must be entered with CTRL-SHIFT-ENTER.
Drag formula down as needed.

Excel Workbook
	A	B	C	D
1	Date	Name	Date	Count
2	1/5/2018	Mike	1/5/2018	4
3	1/5/2018	Mike	1/7/2018	2
4	1/5/2018	Chris	1/10/2018	2
5	1/5/2018	Frank	1/14/2018	1
6	1/5/2018	Chase	1/22/2018	3
7	1/7/2018	Kian
8	1/7/2018	Corey
9	1/7/2018	Corey
10	1/10/2018	Frank
11	1/10/2018	Mark
12	1/14/2018	Frank
13	1/22/2018	Knox
14	1/22/2018	Kian
15	1/22/2018	Mike
16	1/22/2018	Mike
Sheet

 

[XlsXprt]

Try this!

The formula I put in cell E4 is

=SUMPRODUCT((($A$1:$A$15=D2))/COUNTIFS($A$1:$A$15,$A$1:$A$15&"",$B$1:$B$15,$B$1:$B$15&""))

 

[bgurtz]

Thank you so much

 

[bgurtz]

I thought I had this, but i must be doing something wrong, I can not get it to work correct. I have been reading and trying to figure out what I have done wrong with the answers I have been given, but I must be doing it wrong. can anyone upload a sample sheet so i can see what i am doing wrong?

 

[bgurtz]

I just get a 0 (zero) or a #REF !

 

[AhoyNC]

The formula in post #2 is an array formula and must be entered with CTRL-SHIFT-ENTER.

If you just hit the enter key.
Press F2 key for edit.
Then CTRL-SHIFT-ENTER.

Note you can just copy my example into Excel.