| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) )") |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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) )") |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help with a look up forumula I haven't seen before | Excel Worksheet Functions | |||
| New Forumula Issue | Excel Discussion (Misc queries) | |||
| Forumula help using Countif | Excel Worksheet Functions | |||
| COUNT forumula problem | Excel Discussion (Misc queries) | |||
| Help with FORUMULA | Excel Discussion (Misc queries) | |||
![scrabtree23[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
