How can I copy this formula to the right and have the formula in the next adjacent cell increment the Data2!KR$3:KR$16000 by two columns (thus arriving at KT) and the Data2!AD$3:AD$16000 increment by one (thus arriving at AE)?

=SUMIFS(Data2!KR$3:KR$16000,Data2!$M$3:$M$16000,Date!$B$1,Data2!AD$3:AD$16000,1)