Can someone tell me how you go about using the formula array in VBA? I have the following code:

Range("N10").FormulaArray = _
        "=SUM((Miles>=R9C)*(Miles<R9C[1])*(Depth<=RC13)*(Depth>R[1]C13))"

I keep getting an error message stating that "Unable to apply Array Formula" and "Invalid name error"? Any suggestions on how to set the array formula in VBA

Thanks