Additional condition to check if the day worked is a Friday throws an Err502

I am creating a work Spreadsheet with 2 shifts per person. Everyday, I will enter which shifts were worked. At the end of the month I need it to tell me how many Fridays someone has worked.

I can count how many days someone has work. But the additional condition to check if the day worked is a Friday throws an Error.

Days of the week are the top most row on the sheet and pulled with the TEXT function from the date.

COUNTIFS(B3:AF6,“<>“) returns the worked days

COUNTIFS(B3:AF6,“<>“ , $B$1:$AF$1,“Friday“) gives Err 502