|
|
#1
01-22-2014, 02:31 AM
|
|||
|
|||
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 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Average if and sumif
|
jennamae | Excel | 4 | 01-17-2014 05:10 AM |
|
object variable or with block variable not set
|
MJP143 | Excel | 1 | 02-11-2013 05:07 AM |
|
Run-time error '91': Object variable or With block variable not set
|
tinfanide | Excel Programming | 2 | 06-10-2012 10:17 AM |
| Help! 'SUMIF' Formulas | dave1372 | Excel | 2 | 09-08-2011 07:05 AM |
|
Multiple criteria in SUMIF?
|
pumpkin head | Excel | 1 | 02-17-2006 09:06 AM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode