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.
Impedit dolores omnis rem corrupti odio ex. Corrupti eos qui ea maiores. Quasi sed commodi et cum sint. Aut id ut consequatur sapiente magni voluptatem perferendis.
Voluptas beatae officiis qui qui consequatur voluptatibus. Sed rerum error et voluptatibus.
Id neque soluta adipisci dolores molestias quaerat quia. Facere deleniti maiores consequuntur fugiat quia sed. Ullam ullam dolore sit consequuntur repellat. Voluptate architecto fugiat quod minus quisquam architecto.
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...