Skip to content
Related Articles
Get the best out of our app
GeeksforGeeks App
Open App

Related Articles

How to Sum Values Based on Criteria in Another Column in Excel?

Improve Article
Save Article
Like Article
Improve Article
Save Article
Like Article

In Excel, we can approach the problem in two ways. [SUMIF Formula and Excel Pivot]

Sample data: Sales Report Template

We are creating a summary table for Total Product sales.  

Approach 1: Excel Formula SUMIF

Step 1: Copy “Column A” Products and then paste into “Column F”

Step 2: Remove duplicate products in “Column F”

Step 3: Type “Sales” in cell G1.

Step 4: Now make use of the below formula.


SUMIF(range, criteria, [sum_range])


  • range : Required. Excel range of cells, to apply criteria.
  • criteria : Required.  criteria example : 12, “>12”, t7, “5?” or “blue*”.
  • sum_range : optional.  Excel range to add 

Now write SUMIF() in cell G2


Step 5: Select cell G2 and drag till cell G6

Approach 2: Using Pivot table

Step 1: Select the entire data range (A1:C21)

Step 2: Now click Insert >> PivotTable to open the Create PivotTable dialog box

Step 3: In the PivotTable Fields pane, drag the criteria column name (Product) to the Rows section, drag the column you will sum (Sales), and move to the Values section

Pivot Table: Total Products Sales [Column E and F]

My Personal Notes arrow_drop_up
Last Updated : 29 Oct, 2021
Like Article
Save Article
Similar Reads