Question: How do I sum values only if a unique value exists in another column?
Formula in D13:
The ranges don´t have to be adjacent.
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