Close two brackets and hit the enter key to get the result. First method sums the column by matching column heading using MATCH function. Sum Range is nothing but for the provided criteria which column range you want to sum, so choose the Sales column. Now copy the column’s cells with numbers and paste them into a separate sheet or in the same sheet in a different location. For this, we will consider the same data as shown in example-1.