Adding Number Of 'YES' Cells For Rows Of The Same Date

I have attached an example sheet.

Each row starts with today's date in cell A followed by a series of yes/no cells.

In a separate tab of the work sheet I want to automatically show the number of yes/nos of each column for each day.

Hurg

Try in B2:

=SUMPRODUCT((Input!$A$2:$A$6=$A2)*(Input!$B$1:$F$1=B$1)*(Input!$B$2:$F$6="YES"))

Drag down and accross

In B2, =COUNTIFS(Input!$A$2:$A$6,Auto.!$A2,Input!B$2:B$6,"YES") and copy right and down.