Distinct date count in Column A for value in Column B

[coffeeman12]

I've tried multiple suggestions from different boards for this.

Here is what I'd like to do:

Col A Col B
1/1/2020 A
1/1/2020 A
1/4/2020 A
1/5/2020 A
1/1/2020 B
1/2/2020 B
1/4/2020 B
1/5/2020 B

I'd like to count the distinct dates for A in one cell, B in a different cell.

A would = 3
B would = 4

The closest I've come is:
=SUM(IF(FREQUENCY(MATCH(A1:A8,A1:A8,0),MATCH(A1:A8,A1:A8,0))>0,1))
This gives "4"

This formula doesn't allow you to specify whether you want to count the distinct dates for A or B (in column B).
It also does not work if you change the ranges to "A:A" in order to capture the entire column, to allow for changing numbers of rows.

 

[Fluff]

Hi & welcome to MrExcel.
How about

+Fluff New.xlsm
	A	B	C	D	E
1
2	01/01/2020	A		A	3
3	01/01/2020	A		B	4
4	04/01/2020	A
5	05/01/2020	A
6	01/01/2020	B
7	02/01/2020	B
8	04/01/2020	B
9	05/01/2020	B
10
Main

Cell Formulas
Range	Formula
E2:E3	E2	=SUM(--(FREQUENCY(IF($B$2:$B$9=D2,$A$2:$A$9),$A$2:$A$9)>0))
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[coffeeman12]

Wow, this worked. Thank you!

 

[Fluff]

You're welcome & thanks for the feedback.