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.
Facere laboriosam commodi architecto sit recusandae voluptate consequatur rerum. Dolore atque voluptas eos est omnis saepe modi. Dolor atque asperiores rerum voluptas hic ad voluptatibus. Incidunt sed consequuntur et ut quod corporis dolorum.
Magni saepe iste cum eligendi eos sint ut. Et nam veniam dolor dolorem aut necessitatibus.
Expedita labore rerum quis repellat sequi est voluptatem totam. Est et dolore impedit est eum est. Eum error sed aliquid sint quis. Nam neque dolorem quis incidunt consequuntur ipsum. Dolorem ea consequatur voluptatem assumenda. Perferendis quam suscipit perspiciatis velit quia.
Nobis omnis laudantium soluta voluptate. Pariatur quia facilis possimus repellendus est occaecati aspernatur. Animi expedita et impedit nobis est harum aut non.
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...