Loop function SUMIFS

Use something like this

dim counter as long
dim count as long
count = 99
     for counter = 2 to 12 'just change the 12 as needed
          range("CX"&counter).formulaR1C1 = "=SUMIFS(C[-101],C[" & count & "],RC[-4],C[-100],"""")"
          count = count - 1
     next