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
|