Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

about FormulaArray and RC notation

  • Thread starter Thread starter xq
  • Start date Start date
Status
Not open for further replies.

xq

Programmer
Joined
Jun 26, 2002
Messages
106
Location
NL
i have problem with RC notaion

Worksheets("TotValume").Range("D3:D10").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

 
hope u will understand my question, thanks a lot if anybody could help me out!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top