Need help in Excel SUMIFS + MATCH

Originally Posted by 6StringJazzer

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.

Thank you. It works.