Thread: Need help sumif with variable for VBA
View Single Post
 
Old 01-22-2014, 02:31 AM
jingo jingo is offline Windows 7 32bit Office 2010 32bit
Novice
  
Join Date: Jan 2014
Posts: 1
jingo is on a distinguished road
Default Need help sumif with variable for VBA
i try to use use VBA as below but not work, can someone help me to fix it.
how we can use "</ >" with variable

numyear = Range("B3").Value
tillww = Range("D2").Value

ActiveCell.FormulaR1C1 = "=SUMIFS(C[-8],C[-4],RC[-1],C[-15]," & numyear & "C[-7], ""<= "" & tillww & ")"

Thank you
Reply With Quote