Hi
I am using a simply Sumifs formula, however this is across a data range that will change
This is the formula and works as is
Range("L6").Select
ActiveCell.Formula = "=SUMIFS('Apps Indicative Earnings Report'!$K$11:$K$73,'Apps Indicative Earnings Report'!$G$11:$G$73,'INVOICE CALC'!H6,'Apps...