Unique Countifs

[Pestomania]

Hello,

I am trying to identify how to do a countif using only unique values that show up in the "Work Center" column. I used a few different forums to try and figure out without luck.

Prestons Playground for Modeling.xlsx
	A	B	C	D	E	F	G
1	ToolCode	# of Equipment Down	Actual Number		UDF_DATE	UDF_WORKCENTER	Current Down Time
2	GRP	2	1		2/20/2024 0:00	GRP6	Yes
3	BSA	1	1		2/28/2024 0:00	BSA1	Yes
4	CRB	0	0		3/1/2024 0:00	PCK2	Yes
5	DG	0	0		3/2/2024 0:00	GRP6	Yes
6	IMP	0	0		2/18/2020 0:00	CRB2	No
7	PCK	2	2		2/18/2020 0:00	CRB3	No
8	OVEN	0	0		2/25/2024 0:00	PCK4	Yes
9
10
11	I am trying to get the "actual number" which is how many "unique" work center records are listed as "yes" for current down time. So I only want to count GRP6 one time instead of twice.
12
13
14
Sheet6

Cell Formulas
Range	Formula
B2:B8	B2	=COUNTIFS($F$2:$F$8,A2&"*",$G$2:$G$8,"Yes")
G2:G8	G2	=IF(AND(E2>=TODAY(),E2<TODAY()+30),"Yes","No")

 

[Fluff]

How about

=IFERROR(ROWS(UNIQUE(FILTER($F$2:$F$8,(LEFT($F$2:$F$8,LEN(A2))=A2)*($G$2:$G$8="Yes")))),0)

 

[Pestomania]

How about

=IFERROR(ROWS(UNIQUE(FILTER($F$2:$F$8,(LEFT($F$2:$F$8,LEN(A2))=A2)*($G$2:$G$8="Yes")))),0)

The things you manage to do absolutely floor me!

Thank you,

 

[Fluff]

Glad to help & thanks for the feedback.