## Saturday, July 20, 2013

### yogi_Compute Year By Year SquareFootage And Rent For LeaseEnd Year

Google Spreadsheet   Post  #1297
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul 20, 2013

This relates to a solution I had posted back in 2008 to a question http://www.mrexcel.com/forum/excel-questions/318383-rent-roll-help.html#post3524509
in MrExcel.com help forum wherein I had used Excel's DataTable feature. Today I was prompted for solution to a followup question from that thread in 2008 -- but this time I used Google's QUERY function for a solution to the original question as well as the followup question

user post by elmsley4 (http://www.mrexcel.com/forum/excel-questions/318383-rent-roll-help.html#post3524739)

## Rent Roll Help!

I feel like an idiot b/c I think this shouldn't be too hard:

I have a table for an office building showing tenants and lease expirations.
I want to show, as a percentage, the amount of tenants leaving in any given year.

Layout:
Column A = Tenant Name
Column B = Lease Start*
Column C = LEASE END*
Column D = SQUARE FEET
Column E = BASE RENT

*Dates are entered as follows: 1/15/2005

I can do this with a funky SUMIF feature (for Sq.Ft and Base Rent calculations), but isn't there something easier?

I want to know:
1. TOTAL Sq.Ft expiring for years 2008 - 2015 and,
2. TOTAL Base Rent expiring for years 2008 - 2015.

Everything else will be easy to calculate. Is there a SUMIF command that will display all leases expiring ONLY in 2009, 2010, 2011, etc...???

Thanks for any help!

-JRG

------------------------------------------------------------------------------------