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...


"Ayo" wrote:

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

"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"Ayo" wrote:

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

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