SUMIF or SUMPRODUCT or any formula for this data set?

If you have dataset A1:D10

Try

F2=IFERROR(INDEX($B$2:$B$10,MATCH(0,INDEX(COUNTIFS($F$1:F1,$B$2:$B$10),),0)),"") and drag down.

G2=SUMPRODUCT((TEXT($A$2:$A$10,"mmm")=G$1)*($B$2:$B$10=$F2)*($D$2:$D$10="Yes")*($C$2:$C$10)) and drag towards the cells and down.

Check the attached file.