google sheets – How to SUMIFS text that begins with apostrophe

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?