SUMIFS in Programming
Hi Graham
One way
Cells(3, 37).Formula = _
"=SUMIFS($N$15:$N$600,$M$15:$M$600,$AK$2,D$15:$D$6 00,AI$3)"
Cells(3, 37).Copy Range(Cells(3, 38), Cells(3, 44))
--
Regards
Roger Govier
Graham wrote:
Below is waht ideally I would like to do with a procedure and I know
this will not work with n in a formula, it was just to show the concept
of what I was after.
I would appreciate any guidance.
Graham
For n = 37 To 44
Cells(3, n).Select
ActiveCell.FormulaR1C1 = _
"=SUMIFS(R15C14:R600C14,R15C13:R600C13,R2Cn,R15C4: R600C4,R3C35)"
Next n
|