I receive a list of products from an external data source. One of the names of the products begins with an apostrophe. When I try to produce a summary of the products and the total quantity using UNIQUE () and SUMIFS (), the formula returns zero for the product that starts with an apostrophe.
I have made an example sheet here:
Interestingly, a VLOOKUP will work fine, but additional entries will be lost in the list.
Does anyone have any ideas on how to solve this without eliminating the main apostrophe?