Need help in Excel SUMIFS + MATCH

Originally Posted by 6StringJazzer

I think you just need a plain vanilla SUMIF. Put this in F6 and then copy down. You will have to change the ranges to include the largest possible number of rows under "List of Rental Property."

=SUMIF($B$14:$B$26,A6,$E$14:$E$26)

This formula sum up rent even if no room is occupied. ex. For Lakeview Apartments, The potential rent is supposed to be 0 as no room is occupied, where as this formula would give us 1750.