Array Formula in A15:

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

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

Download excel sample file for this tutorial.
Comparing two columns and sum unique values.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

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

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

Related posts:

1. Count matching cell values in two columns in excel
2. Count unique values in two lists combined in excel
3. Filter unique values from a range using array formula in excel
4. Merge two columns with possible blank cells in excel (formula)
5. Extract unique values from a range using array formula in excel
6. Filter unique distinct text values using “begins with” criterion in a range using array formula in excel
7. Filter unique distinct list sorted based on sum of adjacent values using array formula in excel
8. Filter common text values in range 1 and in range 2 using array formula in excel