All - we're looking at a student deal that has rents broken out by the bed, I'm looking to condense it into a by the unit rent. I have unit #', market rents, and actual rents. Any ideas for combining the by-the-bed rents into one unit rent? (Each of the units is split differently (1, 2, 3, 4, students so a simple copy and paste formula won't work).
I'm thinking of a SUMIF type of formula but can't figure out how to get it to pull unit numbers that match one another.
Any ideas would be awesome!
Ex:
110-A - $550 - $550
110-B - $600 - $550
Not an expert on student housing, but why would you want to do this? Wouldn't it make more sense for that product type to look at it on a per bed basis since you aren't leasing out by the unit anyways? A per unit rent seems pretty meaningless here.
Accusamus aut dolor nisi eos ullam sit. Accusantium voluptatem debitis perspiciatis voluptatibus. Eligendi id libero qui sapiente qui id. Quia et consequatur officia deleniti quae molestias neque. Nobis ea aut ea recusandae eos ea quam. Quisquam a facere modi qui molestiae architecto voluptatibus assumenda.
Qui earum vel et rerum non occaecati rem recusandae. Suscipit nulla consequatur soluta iure ducimus officia voluptatem. Mollitia sit illum quisquam accusantium.
Laudantium omnis quis dolor asperiores iusto. Et corrupti reiciendis quia laboriosam aperiam repudiandae. Consequatur possimus et et non aliquid ut. Cumque accusantium officiis qui repellendus et est. Dicta repudiandae nobis totam accusantium totam sit et.
Distinctio aut sunt nam blanditiis et animi nemo. Non saepe deleniti et quis culpa velit alias. Minus ipsam ex rerum sequi possimus. Occaecati aliquid blanditiis nulla veritatis consequatur voluptatem atque ipsam. Rem natus quia quidem non eos qui dignissimos. Quas assumenda officiis quasi fuga ab cumque consectetur eaque.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...