How to use the AVERAGEIFS function to calculate on the condition of "Containing a specific string".(Microsoft Excel)
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.
Contents
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".
=AVERAGEIFS(C4:C10,B4:B10,"*o*")
Start with
Place "*" after the search criteria.
In the formula below, the condition is that it starts with "ca".
=AVERAGEIFS(C4:C10,B4:B10,"ca*")
End with
Place "*" before the search criteria.
In the formula below, the condition is that it ends with "e".
=AVERAGEIFS(C4:C10,B4:B10,"*e")
---