i have problem with RC notaion
Worksheets("TotValume"
.Range("D3
10"
.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"
"=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