Thread: string matching
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
adimar adimar is offline
external usenet poster
 
Posts: 49
Default string matching

Please help me understand why these apparently equivalent constructs behave
differently? I use them as multipliers in SUMPRODUCT.

The formula is something like:
=SUMPRODUCT((Product={"MGC","EMS"})*(Type={"Servic e Issue","Upgrade"}))


This one does not work as expected: (Type={"Service Issue","Upgrade"})

This one does work as expected: ((Type="Service Issue") + (Type ="Upgrade"))

I expect the formula to count records of Type "Service Issue" OR "Upgrade",
that is allow for either.


Thank you,
Marta