Counting sick days from a row

[mistersteve]

As Usual, I need some help
I require to count how many "Si" on Mondays, Tuesdays, etc that have occurred
See Below John has taken 3 Fridays, 2 Mondays

Can anyone please advise the formula

 

[Fluff]

Maybe

=countifs(f14:z14,"Si",f11:z11,"M")

for Monday

 

[JimM]

Maybe

=countifs(f14:z14,"Si",f11:z11,"M")

for Monday

Problem is going to be with Tuesday and Thursdays, could you change one of the 'T's to either Tu or Th (it will be the same issue for Sat and Sun)

 

[Fluff]

Good point.
Another option, for Tuesday

=SUMPRODUCT((F14:Z14="Si")*(WEEKDAY($F$11:$Z$11,2)=2))

 

[mistersteve]

Thanks Again,

I stuck with the first formula and changed Ts to Tu and Th
Sat and Sun not an issue

 

[Fluff]

Glad we could help & thanks for the feedback.