View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
wesley holtman wesley holtman is offline
external usenet poster
 
Posts: 17
Default Average If Problem

Can anyone, really quick, tell me where I am going wrong with the
formula below? I added a watch to all of the variables and all are
returning the correct values, but I keep getting a Run-time error
'1004':

MTDrng1.FormulaR1C1 =
"=AVERAGEIF(R[totalPopRow]C21:R[-2]C21,CURRMONNUM,R[totalPopRow]C[0]:R[-2]C[0])"