• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

'Sumifs' to get Sum of Square Feet in a Table

djk

New Member
Ninjas, I'm trying to use 'SUMIFS' to get the total square feet of the 'x' most recent leases. I've attached a workbook. Can anyone suggest a solution please? Thanks!
 

Attachments

  • Rent Roll.xlsx
    132.3 KB · Views: 7
Alan, that works to count ALL the "New" leases, but I want to specify how many to count, the first 5, 10, 15, etc for instance.
 
Try,

1] Output Table put in K338:M342, please see attached file.

2] In L339, formula copied across to M339 and all copied down :

=SUM(OFFSET($E$10,MATCH(L$338,$K$10:$K$331,0)-1,0,$K339))

Regards
Bosco
 

Attachments

  • Rent Roll (2).xlsx
    127.7 KB · Views: 5
Back
Top