Hello,
I have the following sumifs formula that I would like to get first three characters out of a cell reference a1 that contains the word Bolivia. I have a list of several countries that i need the result but have several other text right after the name of the country. This way works great: Instead of typing it for every country like this:
SUMIFS(PEBk,PSL_5,"Bol**")
Instead of typing it for every country like this, which works great, I would like to use column A that has a list of countries. How can I use the cell reference to express this part "Bol***"
Thank you very much.
Bookmarks