Let’s see how to use contain operator in sumif formula in excel.
We will use Sumif formula with text that contains a particular string.
Below is the data that products revenue by date and we are interested to see the revenue of the products that contain “del” in the product name. We will use “*” a wildcard operator in excel that means 1 or more character.
Enter the formula below in the cell G2
=SUMIF(A2:A20,”del*”,C2:C20)
As you could see in the formula we have the given condition as “del*” means the name should start with “del” followed by 1 or more character.
If you are not sure that the product name contains “del” at the beginning or not, then use “*del*” which will filter the result for any name that contains “del” in the name.
These are known as wildcard operators in excel.
Hope this helped.
