John,

Without testing:

MsgBox Evaluate("SUMPRODUCT((IndivStats!L5:L65536=""" & MyString &
""")*(IndivStats!S5:S65536))")

Rob


"John Wilson" wrote in message
...
Hi guys (and gals),

I have this:

MsgBox Evaluate("SUMPRODUCT((IndivStats!L5:L65536=""Bosto n Garden
{1}"")*(IndivStats!S5:S65536))")
Thanks Tom.

What I can't figure out........

Dim MyString as String
MyString = "Boston Garden {1}"

How do I subtitute MyString in the above formula???
I can't seem to get it to work.

Thanks,
John