Error 2029. How do I fix this error

[Ayo]

c.Offset(0, 2) = Evaluate("=SUMPRODUCT(--('BO Download'!$B$" & DIregion_sRow
& ":$B$" & BOReport_lastRow & "=" & c.Value & "),--('BO Download'!$F$" &
DIregion_sRow & ":$F$" & BOReport_lastRow & "=" & c.Offset(0, 1) & ")," & _
"--('BO Download'!$H$" & DIregion_sRow &
":$H$" & BOReport_lastRow & "=""Selected""))")

c.Offset(0, 2)=Error 2029

where:
c.Value="INDIANAPOLIS IN"
c.Offset(0, 1)="ZAYO BANDWIDTH"

 

[Jacob Skaria]

Try the below..

c.Offset(0, 2).Formula = Evaluate("=SUMPRODUCT(" & _
"('BO Download'!B" & DIregion_sRow & ":B" & BOReport_lastRow & _
"=""" & c.Value & """)*" & "('BO Download'!F" & DIregion_sRow & _
":F" & BOReport_lastRow & "=""" & c.Offset(0, 1) & """)*" & _
"('BO Download'!H" & DIregion_sRow & ":H" & _
BOReport_lastRow & "=""Selected""))")

If this post helps click Yes

 

[Ayo]

I am having a bigger problem that that. Is there somewhere I can send the
file to you so that you can take a look at the rest of the code for me? Thanks

 

[Rick Rothstein]

You can post it online using one of these free posting websites...

http://www.mediafire.com/
http://www.freefilehosting.net/
http://savefile.com/

 

[Jacob Skaria]

I have tried the below formula and it works for me.

OR else try your original formula with slight changes...Please note the
change in double quotes in my formula...