Pestomania
Active Member
- Joined
- May 30, 2018
- Messages
- 292
- Office Version
- 365
- Platform
- Windows
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.
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 |