How to select data from multiple columns using a formula

[praveenv]

I have raw data in multiple columns. I have created a seperate table to capture this data using countifs. I'm stuck at one place where i've to capture the data for a particular day from multiple columns.

Here is the example table.
[TABLE="class: outer_border, width: 640"]
<colgroup><col style="width:48pt" span="10" width="64"> </colgroup><tbody>[TR]
[TD="width: 64"]Shift Time
[/TD]
[TD="width: 64"]Schedule[/TD]
[TD="width: 64"]Week Off[/TD]
[TD="width: 64"]Sun[/TD]
[TD="width: 64"]Mon[/TD]
[TD="width: 64"]Tue[/TD]
[TD="width: 64"]Wed[/TD]
[TD="width: 64"]Thu[/TD]
[TD="width: 64"]Fri[/TD]
[TD="width: 64"]Sat[/TD]
[/TR]
[TR]
[TD]21:00-08:00[/TD]
[TD]Sat-Wed[/TD]
[TD]Fri[/TD]
[TD]W[/TD]
[TD]W[/TD]
[TD]W[/TD]
[TD]W[/TD]
[TD]W[/TD]
[TD]W[/TD]
[TD]W
[/TD]
[/TR]
[TR]
[TD]21:00-08:00[/TD]
[TD]Sat-Wed[/TD]
[TD]Thu,Fri[/TD]
[TD]P[/TD]
[TD]HSL[/TD]
[TD]2+P[/TD]
[TD]W[/TD]
[TD]W[/TD]
[TD]W[/TD]
[TD]W[/TD]
[/TR]
[TR]
[TD]8:00-17:00[/TD]
[TD]Sat-Wed[/TD]
[TD]Fri[/TD]
[TD]SL[/TD]
[TD]P[/TD]
[TD]P[/TD]
[TD]P[/TD]
[TD]SL[/TD]
[TD]Off[/TD]
[TD]SL
[/TD]
[/TR]
[TR]
[TD]8:00-17:00[/TD]
[TD]Sat-Wed[/TD]
[TD]Thu,Fri[/TD]
[TD]SL[/TD]
[TD]SL[/TD]
[TD]W[/TD]
[TD]W[/TD]
[TD]W[/TD]
[TD]USL[/TD]
[TD]W[/TD]
[/TR]
[TR]
[TD]8:00-17:00[/TD]
[TD]Fri-Tue[/TD]
[TD]Thu[/TD]
[TD]W[/TD]
[TD]W[/TD]
[TD]W[/TD]
[TD]W[/TD]
[TD]W[/TD]
[TD]W[/TD]
[TD]W[/TD]
[/TR]
[TR]
[TD]17:00-04:00[/TD]
[TD]Fri-Tue[/TD]
[TD]Thu[/TD]
[TD]W[/TD]
[TD]W[/TD]
[TD]W[/TD]
[TD]W[/TD]
[TD]W[/TD]
[TD]W[/TD]
[TD]W[/TD]
[/TR]
[TR]
[TD]17:00-04:00[/TD]
[TD]Fri-Tue[/TD]
[TD]Thu[/TD]
[TD]W[/TD]
[TD]W[/TD]
[TD]W[/TD]
[TD]W[/TD]
[TD]W[/TD]
[TD]W[/TD]
[TD]W[/TD]
[/TR]
[TR]
[TD]21:00-08:00[/TD]
[TD]Fri-Tue[/TD]
[TD]Thu[/TD]
[TD]W[/TD]
[TD]W[/TD]
[TD]W[/TD]
[TD]W[/TD]
[TD]W[/TD]
[TD]W[/TD]
[TD]W[/TD]
[/TR]
</tbody>[/TABLE]


I have created a dropdown in seperate table to select shift time, schedule, weekoffs and day seperately. Using countifs formula, I'm able to get data for a particular shift time, schedule and one day.

So when i select any other day from the dropdown, the data should be captured automatically for that day.

I need to formulate this to capture a particular day's autumatically. Please help.