Thread: text in forumula problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
scrabtree23[_3_] scrabtree23[_3_] is offline
external usenet poster
  
Posts: 55
Default 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) )")
Reply With QuoteReply With Quote