That adds some clarification.

=SUMIF($B$14:$B$26,A6,$E$14:$E$26)*--(COUNTIFS($B$14:$B$26,A6,$F$14:$F$26,"Yes")>0)

For each property, this formula calculates the sum of all units if any unit is occupied. If no unit is occupied, it returns 0.