Extracting Row Numbers from Specific Values

[Tingchi]

Hi, I am creating a training tracker for my company. The current program uses 1's to delineate certified employees. These are the headers to my Table

The columns in orange indicate a task to be certified in.

My company has asked me to track the %trained for each shift. (1st,2nd,3rd) Is there a way for me to pull the rows of employees based on their shift? Then I can use the function 

=CountA((Extractedrows(E:V))/(Countblank(Extractedrows(E:V)) +CountA((Extractedrows(E:V))) 

to calculate percentage of employees trained per shift

'Extractedrows' = Numbers of rows that include either '1st', '2nd', or '3rd' shifts

[#2]

@Tingchi 

As variant that could be

=SUMPRODUCT((shiftColumnRange="1st")*(tasksRange<>""))

where for example first range is C2:C100 and second one E2:E100. Similar to calculate blank cells, just change <> on = .