Excel SUMIF or uses a filter implementation to pick values that contain certain fields, and then add the values on the subsequent column corresponding to those values

Background:

Select the values that contain some fields, and then add the values that correspond to the columns that follow the values. For example, pick the value of all the fields with "MX104" in the table below, and then add the value of the column after it.

Solution:

Randomly choose a A16 this position to record this number, the formula is =SUMIF (a2:a12, "*mx104*",d2:d12), the resulting value is 107784.6, which is the sum of the values of the D column of the cells containing the MX104.

You can also use filters to achieve the same effect:

Add a filter to A1, such as, and then filter MX104 such as

However, it is important to note that although the required values are listed in column D, but not directly sum (D2:D12), and can not drag the mouse to filter out the column D, because he actually add the source data, so the value is not the same as before SUMIF, so this is more troublesome, You have to input =sum (D5+D6+D8=D10 ...) all plus that value is the same as the value obtained in the previous sumif.

Excel SUMIF or uses a filter implementation to pick values that contain certain fields, and then add the values on the subsequent column corresponding to those values