The SUMIFS function works in a similar way with text as with numbers, but there are two key differences. First, text in Excel ...

Many or all of the products here are from our partners that compensate us. It’s how we make money. But our editorial integrity ensures that our product ratings are not influenced by compensation.