Sum only if unique value in another column in excel

Popular categories

Dashboard reporting with excel This e-book teaches you how to create your own Excel dashboard reports, starting from scratch. Learn how to create mini-charts, how to use Excel's Camera tool, how to set up Excel databases, and a lot more.

Excel Worksheet-Formula Add-Ins allows worksheet formulas to change chart settings. For the first time ever, your formulas can create traffic-light charts, highlight chart elements, assign number formats, and much more.

Get Digital Help > Excel > Unique values > Sum only if unique value in another column in excel

← Previous post -

Filed in Excel, Unique values on Jun.25, 2009. Email This article to a Friend

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

Answer:

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.
sum-only-if-unique-value-in-another-column.xls
(Excel 97-2003 Workbook *.xls)

Functions in this article:

COUNTIF(range,criteria)
Counts the number of cells within a range that meet the given condition

IF(logical_test;[value_if:true];[value_if_false])
Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE

SUM(number1,[number2],)
Adds all the numbers in a range of cells

Count unique distinct values in a column in excel

Extract a list of duplicates from a column using array formula

Extract a list of alphabetically sorted duplicates from a column in excel

Comparing two columns and sum unique values using array formula in excel

Unique list to be created from a column where an adjacent column has text cell values