Japanese version. Here we will show you how to use the AVERAGEIFS function to perform aggregation under the “contains a specific string” condition.The AVERAGEIF function can be used in the same way. Steps Use a feature called wildcards in the conditions. Contains Place “*” before and after the search criteria. In the formula below, the condition is “contains o”. Start with Place “*” after the search criteria. In the formula below, the condition is that it starts with “ca”. End with Place “*” before the search criteria. In the formula below, the condition is that it ends with “e”. Links Tips. Others.(Microsoft Excel)