Then type in the cell =SUMIF ( We are going to look for the Range ... Read next: How to create a Pivot Table and Pivot Chart in Excel.

You can simply type B2 or click the cell B2 to have Excel search for the text it contains. Using SUMIF with both a criteria range and a sum range. This function is useful for piecing together text ...