countif multiple criteria but ignore duplicates

[SKooLZ]

Hi Guys, hope you can help me with a countif formula to count the days the running activity was done and ignore the amount of times it might have been done in the same day. The count for running days must equals 3 in the example table below.

Activity	Date		Total Running Days	?
Running Track	08/06/2015
Running Track	08/06/2015
Running Fell	09/06/2015
Swimming	01/06/2015
Hockey	02/02/2015
Swimming	03/03/2015
Volleyball	04/03/2015
Running Track	04/04/2015
Running Track	04/04/2015

<tbody>
</tbody>

Also, is this possible without using an array formula?

Many thanks in advance...

 

[Aladin Akyurek]

Are you wanting to count the number of distinct days for the 'running track' activity?

 

[SKooLZ]

Hi Aladin Akyurek, thanks for your prompt response.

Yes, distinct days for the cells containing the word 'Running'

Many Thanks..

 

[Aladin Akyurek]

Hi Aladin Akyurek, thanks for your prompt response.

Yes, distinct days for the cells containing the word 'Running'

Many Thanks..

Row\Col	A​	B​	C​	D​
1​	Activity	Date		# distinct days:
2​	Running Track	8/6/2015​		running
3​	Running Track	8/6/2015​		3​
4​	Running Fell	9/6/2015​
5​	Swimming	1/6/2015​
6​	Hockey	2/2/2015​
7​	Swimming	3/3/2015​
8​	Volleyball	4/3/2015​
9​	Running Track	4/4/2015​
10​	Running Track	4/4/2015​

D3, control+shift+enter (cse), not just enter:

=SUM(IF(FREQUENCY(IF(ISNUMBER(SEARCH(D2,$A$2:$A$10)),$B$2:$B$10),$B$2:$B$10),1))

By the way, no need to worry about an array-processing formula, requiring cse.