i have problem with RC notaion
Worksheets("TotValume".Range("D310".FormulaArray = _
"=SUMPRODUCT((IF(MONTH('Sheet'!R2C7:R300C7) = _
MONTH(R2C4),IF(YEAR('Sheet'!R2C7:R300C7) = YEAR (R2C4), _
IF('Sheet'!R2C5:R300C5=RC[-3],1,0),0),0)), 'Sheet'! _ R2C9:R300C9 )"
every thing works fine except one place, problem is at last if statement:
IF('Sheet'!R2C5:R300C5=RC[-3],1,0)
this RC[-3] doesn't work, it's always fixed on $A3, i want it changes as D moves from 3 to 10
Worksheets("TotValume".Range("D310".FormulaArray = _
"=SUMPRODUCT((IF(MONTH('Sheet'!R2C7:R300C7) = _
MONTH(R2C4),IF(YEAR('Sheet'!R2C7:R300C7) = YEAR (R2C4), _
IF('Sheet'!R2C5:R300C5=RC[-3],1,0),0),0)), 'Sheet'! _ R2C9:R300C9 )"
every thing works fine except one place, problem is at last if statement:
IF('Sheet'!R2C5:R300C5=RC[-3],1,0)
this RC[-3] doesn't work, it's always fixed on $A3, i want it changes as D moves from 3 to 10