try putting green in double or triple quotes i forget which
OutReach.Value = WS.Evaluate("=SUMPRODUCT((B1:B10=1)*(D1:F10=""gree n""))")


OutReach.Value = WS.Evaluate("=SUMPRODUCT((B1:B10=1)*(D1:F10="""gre en"""))")
--
When you lose your mind, you free your life.


"scrabtree23" wrote:

Why is the word green giving me a problem here? This word exists in the
range D1:F10, but the formula has a problem with "Green".



OutReach.Value = WS.Evaluate("=SUMPRODUCT((B1:B10=1)*(D1:F10=green) )")