Formula muy larga.

Error definido por la aplicación o el objeto:

range("b" & i).formula = _
        "=if(countifs([actual.xls]base!$bv:$bv,b$5,[actual.xls]base!$an:$an,$a7,[actual.xls]base!$a:$a,b$4,[actual.xls]base!$bw:$bw,&" _
        & """<=""&menu!$l$1,[actual.xls]base!$bu:$bu,""<=""&menu!$l$2)+countifs([inst.xls]base!$bv:$bv,b$5,[inst.xls]base!$an:$an,$a7,[inst.xls]base!$a:$a,b$4,&" _
        & "[inst.xls]base!$bw:$bw,""<=""&menu!$l$1,[inst.xls]base!$bu:$bu,""<=""&menu!$l$2)+countifs([origen.xls]base!$bd:$bd,""<>""&$a7,[origen.xls]&" _
        & "base!$br:$br,b$5,[origen.xls]base!$a:$a,b$4,[origen.xls]base!$bp:$bp,""<=""&menu!$l$1,[origen.xls]base!$bq:$bq,""<=""&menu!$l$2)=0,""-"",&" _
        & "countifs([actual.xls]base!$bv:$bv,b$5,[actual.xls]base!$an:$an,$a7,[actual.xls]base!$a:$a,b$4,[actual.xls]base!$bw:$bw,""<=""&menu!$l$1,[actual.xls]base!$bu:$bu,""<=""&menu!$l$2)&" _
        & "+countifs([inst.xls]base!$bv:$bv,b$5,[inst.xls]base!$an:$an,$a7,[inst.xls]base!$a:$a,b$4,[inst.xls]base!$bw:$bw,""<=""&menu!$l$1,[inst.xls]&" _
        & "base!$bu:$bu,""<=""&menu!$l$2)+countifs([origen.xls]base!$bd:$bd,""<>""&$a7,[origen.xls]base!$br:$br,b$5,[origen.xls]base!$a:$a,b$4,[origen.xls]&" _
        & "base!$bp:$bp,""<=""&menu!$l$1,[origen.xls]base!$bq:$bq,""<=""&menu!$l$2))"