mercredi 11 novembre 2020

Excel Help ratio with sumproduct

Date of Hire Plan Participant 1/6/2020 Yes 5/6/2020 Yes 3/6/2020 No 1/1/1900 Yes

I have table above and want to get a ratio when date of hire is greater than 11/11/2019 and plan participant is 'YES'. the Ratio would be 2/3

This is what I have but it's returning 3 instead of 2.

=SUM(IF(($A$2:$A$7>DATE(2019,11,11))*(SUMPRODUCT(--($B$2:$B$7="Yes"))),1,0))

Aucun commentaire:

Enregistrer un commentaire