Late in the day - in the attached one column added to the source table: in G4 a formula:
Code:
=SUMPRODUCT(--($A$4:$A$19=$A4),--($B$4:$B$19=$B4),($C$4:$C$19="Y")+($E$4:$E$19="Y")+($F$4:$F$19="Y")+($D$4:$D$19="Y"))
copied down.
Then 2 pivot tables (using the data model to be able to use Distinct Count)