Thread: Sumproduct Formula Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Harley Harley is offline
external usenet poster
  
Posts: 16
Default Sumproduct Formula Help
=SUMPRODUCT((ISNUMBER(FIND({"FLH","FLT"},L2:L100)) )*(M2:M100="N"),P2:P100


The two strings are creating an error? Formula works fine with one text
string. Anyway to resolve?

harley
Reply With QuoteReply With Quote