Author: Oscar Cronquist Article last updated on February 26, 2018

Question: How do I sum values only if a unique value exists in another column?



Formula in D13:

=SUM(IF(COUNTIF(List1, List1)=1, List2, 0)) + CTRL + SHIFT + ENTER

The ranges don´t have to be adjacent.

Named ranges
List1 (A2:A11)
List2 (B2:B11)
What is named ranges?

How to customize the formula to your excel sheet
To copy this formula in to your excel spreadsheet you don´t need to edit the formula.  Only change the named ranges.

Download excel sample file for this tutorial.
(Excel 97-2003 Workbook *.xls)

Functions in this article:

Counts the number of cells within a range that meet the given condition

Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE

Adds all the numbers in a range of cells