Sumifs

[Kennethy86]

SUMIFS(input_table[Quoted Rent],input_table[GO Date],"<="&'current&future_streams_combined'!B$75,input_table[Licencee],'current&future_streams_combined'!$A76,input_table[City],"<>NEW")

I'm currently using this formula to lookup and sum the rents by licensee from my data table where the date on my formula page is greater than the go date on the input table, which is when rents will be due. Any idea how I could build in an escalation of rent at 2 percent compounded annually?

Sep-18	Oct-18	Nov-18	Dec-18	Jan-19	Feb-19	Mar-19	Apr-19	May-19	Jun-19	Jul-19	Aug-19	Sep-19	Oct-19	Nov-19
-	-	-	4,035	4,035	4,035	4,035	4,035	4,035	4,035	4,035	4,035	4,035	4,035	4,035
-	-	-	4,280	4,280	4,280	4,280	4,280	4,280	4,280	4,280	4,280	4,280	4,280	4,280
-	-	-	-	-	-	-	4,075	4,075	4,075	4,075	8,355	8,355	8,355	8,355
-	-	-	8,150	8,150	8,150	20,267	20,267	24,807	33,207	33,207	33,207	33,207	33,207	33,207
-	-	-	-	-	-	-	4,050	4,050	16,720	21,550	21,550	21,550	21,550	21,550
-	-	-	3,500	3,500	3,500	3,500	3,500	3,500	3,500	3,500	3,500	3,500	3,500	3,500
37,800	37,800	37,800	37,800	37,800	37,800	37,800	37,800	37,800	37,800	37,800	37,800	37,800	37,800	37,800
-	-	-	-	-	-	4,000	4,000	4,000	4,000	4,000	4,000	4,000	4,000	4,000
37,800	37,800	37,800	57,765	57,765	57,765	73,882	82,007	86,547	107,617	112,447	116,727	116,727	116,727	116,727

<colgroup><col><col span="14"></colgroup><tbody>
</tbody>