Count cells which match a single criterion across an array of cells

Hi folks,

Would really appreciate some help - been scratching my head with this all night...

I'm trying to count the number of cells which match a single criteria, across an array of cells. Please see attached sample dataset.

In cell B2, I need a formula to count all weekend cells (e.g. F2:G2,M2:N2,T2:U2,AA2:AB2) which contain the text string "OD". For B2, the formula should return 7. For B3, the formula should return 4 (F3:G3,M3:N3,T3:U3,AA3:AB3. For B4, the formula should return 5 (F4:G4,M4:N4,T4:U4,AA4:AB4).

My dataset is much larger than the example I've uploaded, and I successfully managed to get "COUNTIF" working, but unfortunately my formula ended up having too many arguements. I think HSTACK might be the way to go, but I can't figure out how to get this working properly.

Any help greatly appreciated...!!

Weekend Counting.xlsx

In B2 put this formula:
=SUMPRODUCT(--(WEEKDAY($C$1:$AC$1,2)>=6)*--(C2:AC2="OD"))
... and copy down.

Thanks GlennUK - worked a charm 👍