Here we will show you how to use the COUNTIFS function to perform aggregation under the "contains a specific string" condition.
The COUNTIF 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".
=COUNTIFS(B4:B10,"*o*")
Start with
Place "*" after the search criteria.
In the formula below, the condition is that it starts with "ca".
=COUNTIFS(B4:B10,"ca*")
End with
Place "*" before the search criteria.
In the formula below, the condition is that it ends with "e".
=COUNTIFS(B4:B10,"*e")
---