Count Unique Values with criteria

[Maxwellis]

Mississauga	15-12-03
Scarborough	15-12-01
Partner Event	15-12-03
Scarborough	15-12-01
Mississauga	15-11-26
Scarborough	15-12-01
Mississauga	15-11-26
Scarborough	15-12-01
Scarborough	15-12-01
Mississauga	15-11-26
Mississauga	15-11-26
Scarborough	15-12-01
Mississauga	15-11-26
Mississauga	15-11-26

<tbody>
</tbody>

Hello, I'm trying to count the number of unique dates when the cell in column A = Scarborough or Mississauga, or more options. I am using google sheets by the way (for work)

 

[admiral100]

Hi,

You can try this one : Ctrl+Shift+Enter NOT just Enter

=SUM(IF(FREQUENCY(IF(A1:A14="Scarborough",1*(B2:B14)),IF(A1:A14="Scarborough",1*(B1:B14)))>0,1))

 

[JoeMo]

Here's a solution that requires a helper column (col C) which can be hidden:

Excel Workbook
	A	B	C	D	E
1	Mississauga	15-12-03	Mississauga|15-12-03	Mississauga	Scarborough
2	Scarborough	15-12-01	Scarborough|15-12-01	3
3	Partner Event	15-12-03
4	Scarborough	15-12-01	Scarborough|15-12-01
5	Mississauga	15-11-26	Mississauga|15-11-26
6	Scarborough	15-12-01	Scarborough|15-12-01
7	Mississauga	15-11-26	Mississauga|15-11-26
8	Scarborough	15-12-01	Scarborough|15-12-01
9	Scarborough	15-12-01	Scarborough|15-12-01
10	Mississauga	15-11-26	Mississauga|15-11-26
11	Mississauga	15-11-26	Mississauga|15-11-26
12	Scarborough	15-12-01	Scarborough|15-12-01
13	Mississauga	15-11-26	Mississauga|15-11-26
14	Mississauga	15-11-26	Mississauga|15-11-26
Sheet2