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:

https://docs.google.com/spreadsheets/d/191bqjUPPPtt5ZKeTw7pUplsve-tBdDBhpBV0Ic3e-nA/edit?usp=sharing

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?