Find Unique Entries for Days

[speth]

Hello,

I have information laid out in the following:

Col A: Date
Col B: Time
Col C: WeekNum
Col D: Category
Col E: Details

I have multiple entries per day at different times, and I'm attempting to pull a weekly report for days with unique (distinct?) values. I've tried to wrap my brain around this with a sumproduct/countifs, but no success.

What I'm essentially trying to count is....

Col C (WeekNum) = specific number
Col E (Details) = contains the term "blue"
Col A (Date) = count the unique days where the above is true

So I'm looking for days in a week where "blue" is part of the details. Blue could show up multiple times per day, or not at all on some days, that's what's kind of tripping me up.

 

[Fluff]

How about

ZFluff.xlsm
	A	B	C	D	E	F	G	H
1
2	01/01/2020		1	This is blue				blue
3	02/01/2020		1	This is red			1	2
4	03/01/2020		1	Blue Black & white			2	3
5	04/01/2020		1	Black & white
6	05/01/2020		1	But red all over
7	06/01/2020		2	blue
8	07/01/2020		2	red
9	08/01/2020		2	white
10	09/01/2020		2	blue
11	10/01/2020		2	blue
12	11/01/2020		2	white
13	12/01/2020		2	black
14	13/01/2020		3
15	14/01/2020		3
Model

Cell Formulas
Range	Formula
H3:H4	H3	=SUM(--(FREQUENCY(IF((ISNUMBER(SEARCH($H$2,$D$2:$D$15))*($C$2:$C$15=$G3)),$A$2:$A$15),$A$2:$A$15)>0))
C2:C15	C2	=ISOWEEKNUM(A2)