ExcelBanter - text in forumula problem

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - text in forumula problem (https://www.excelbanter.com/excel-programming/335097-text-forumula-problem.html)

scrabtree23[_3_]

text in forumula problem

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) )")

ben

text in forumula problem

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) )")

Dave Peterson

text in forumula problem

You have another response at your other thread, too.

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) )")

--

Dave Peterson

All times are GMT +1. The time now is 01:05 AM.