Hello everyone,

Can you help me build this loop for the next function? Thanks!!

'SUMIFS FOR PT
    Range("CX2").Select
    ActiveCell.FormulaR1C1 = "=SUMIFS(C[-101],C[-99],RC[-4],C[-100],"""")"
    Range("CX3").Select
    ActiveCell.FormulaR1C1 = "=SUMIFS(C[-101],C[-98],RC[-4],C[-100],"""")"
    Range("CX4").Select
    ActiveCell.FormulaR1C1 = "=SUMIFS(C[-101],C[-97],RC[-4],C[-100],"""")"
    Range("CX5").Select
    ActiveCell.FormulaR1C1 = "=SUMIFS(C[-101],C[-96],RC[-4],C[-100],"""")"
    Range("CX6").Select
    ActiveCell.FormulaR1C1 = "=SUMIFS(C[-101],C[-95],RC[-4],C[-100],"""")"
    Range("CX7").Select
    ActiveCell.FormulaR1C1 = "=SUMIFS(C[-101],C[-94],RC[-4],C[-100],"""")"
    Range("CX8").Select
    ActiveCell.FormulaR1C1 = "=SUMIFS(C[-101],C[-93],RC[-4],C[-100],"""")"
    Range("CX9").Select
    ActiveCell.FormulaR1C1 = "=SUMIFS(C[-101],C[-92],RC[-4],C[-100],"""")"
    Range("CX10").Select
    ActiveCell.FormulaR1C1 = "=SUMIFS(C[-101],C[-91],RC[-4],C[-100],"""")"
    Range("CX11").Select
    ActiveCell.FormulaR1C1 = "=SUMIFS(C[-101],C[-90],RC[-4],C[-100],"""")"
    Range("CX12").Select
It goes the same until:
ActiveCell.FormulaR1C1 = "=SUMIFS(C[-101],C[-45],RC[-4],C[-100],"""")"