John

Try

MsgBox Evaluate("=sumproduct((L5:L1000=""Boston Garden {2}"")*(S5:S1000))")

Tony

----- John Wilson wrote: -----

Okay, so Sumproduct is not my forte.
I rarely use it.

I have this formula on a worksheet:

=SUMPRODUCT((L5:L1000="Boston Garden {2}")*(S5:S1000))

How can I convert this to VBA??

Thanks,
John