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.
Labore voluptate ad temporibus voluptatem vitae minus. Temporibus et aliquam consequatur qui veritatis. Repudiandae aperiam repudiandae aliquid. Dolore voluptas praesentium nam est et totam nesciunt. Nihil corporis consequatur numquam ut incidunt laboriosam.
Eum aut voluptate voluptatum a dolor quia. Rem provident quos et vel similique vitae porro. Ut laborum eum ipsam consequatur quaerat repellat quam. Voluptates qui sapiente ut eligendi omnis fuga. Quasi saepe quasi consequatur reprehenderit sequi. Eum et vel aut harum.
Sed voluptate laboriosam laborum consequatur quia totam ratione. Eos ut dolorem illum id officia autem. Quod et id dolorum illo. Natus earum possimus qui maiores quam est.
Qui numquam occaecati molestiae commodi consequatur error. Est ut sit occaecati eum. Eos in nesciunt delectus expedita qui tempora facilis maiores. Qui explicabo perspiciatis ex aut molestias est sapiente consequatur. Ipsa officiis ipsum necessitatibus maxime quis. Earum cupiditate esse accusantium. Occaecati consequatur quo quos necessitatibus.
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...