Count based on header name

[Pestomania]

Hi there!!

I need to find a way to "count the Y" based on the header having certain statements. In E2, the formula would be counting the "Y" in that row based on the column header "WVE (E1)" being found in column headers (B1:D1). In this example, it is 1. Row 5 shows that DENS has a value of 2 because 2 "Y" showed up for the DENS groups.

The actual data set is hundreds of rows and 40-50 columns.

StationsAndSkillsGaps (with Training Data).xlsx
	A	B	C	D	E	F
1	EmployeeNo	UDF_WVE_1	UDF_DENS_2	UDF_DENS_3	WVE	DENS
2	1	Y	Y		1	1
3	2	Y			1	0
4	3	Y	Y		1	1
5	5	Y	Y	Y	1	2
6	6			Y	0	1
7	7	Y	Y		1	1
Sheet7

 

[Scott Huish]

Formula in E2: =COUNTIFS($B$1:$D$1,"*WVE*",B2:D2,"Y")
Formula in F2: =COUNTIFS($B$1:$D$1,"*DENS*",B2:D2,"Y")

Copy down.

 

[Pestomania]

Formula in E2: =COUNTIFS($B$1:$D$1,"*WVE*",B2:D2,"Y")
Formula in F2: =COUNTIFS($B$1:$D$1,"*DENS*",B2:D2,"Y")

Copy down.

With minor modifications, I got it to work for me, thank you!