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