I am receiving a list of products from an external data source. One of the product names begins with an apostrophe. When I attempt to produce a summary of the products and total quantity using
SUMIFS() the formula is returning zero for the product that begins with an apostrophe.
I have made an example sheet here:
VLOOKUP will work fine, but that will miss additional entries in the list.
Does anyone have any ideas on how to solve this without removing the leading apostrophe?