Can some one explain, point the error & provide correct code.
The below code is getting the result
.Range("P2:p" & lr).Formula = "=SUMIFS(L:L,I:I,O2,M:M,$P$1)"
But the below code is just summing up only the value of O2
.Range("P2:P" & lr) = WorksheetFunction.SumIfs(.Range("L:L"), .Range("I:I")...