Unanswered: Sumifs statement with non-wild asterisk as criteria
I'm doing a report summarizing data from a detail tab by share code via sumifs formulas. My company apparently thought it was a good idea to have some share codes with asterisks as the first character and this is making it particularly difficult to summarize using sumifs. For example, on my details tab I have both a share type "FC" and a share type "*FC". If I set the latter as the criteria, it pulls the total balance for both types. Is there a way to lock down the asterisk in the sumifs query so that it is not recognized as a wildcard?