D djk New Member Aug 17, 2017 #1 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: 10
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!
AlanSidman Well-Known Member Aug 17, 2017 #2 try this =SUMIFS(E$10:E$331,K$10:K$331,$K337) Last edited: Aug 17, 2017
D djk New Member Aug 17, 2017 #3 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.
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.
B bosco_yip Excel Ninja Aug 17, 2017 #4 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: 8
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
