After launch Excel and retrieve the desired range I think this flow is more suited to get Yes and No counts:
'Set variable' - call variable %YesCount% and set it to 0
'Set variable' - call variable %NoCount% and set it to 0
For each %CurrentItem% in %ExcelData%:
'If' %CurrentItem% = 'Yes' then
'Increase variable', where Variable name = %YesCount% and Increase by = 1
'Else'
'Increase variable', where Variable name = %NoCount% and Increase by = 1
'End'
'End'
At the end, just get %YesCount% and %NoCount% variables.