Re: $$Excel-Macros$$ vba formula vs calculation - problem with "<=" or dates

try.. > . > .Range("q" & i).Formula = *Evaluate(*"=SUMIFS(O$2:O$26196,A$2:A$26196," & > "a" & i & ",N$2:N$26196," & "n" & i & ")"*)* > > -- > Thanks & regards, > Noorain Ansari > w

$$Excel-Macros$$ vba formula vs calculation - problem with "<=" or dates

This formula works in a cell: =SUMIFS(O$2:O$26196,A$2:A$26196,A2,N$2:N$26196,"<="&N2) 1) I want to have vba make this calculation - because calculating it in each cell bogs down the xls. I got the following vba to work but I cant figure out how to add "<=" to the last clause (col N has dates): .R