Sum two columns, duplicates count as one

[NHagedorn]

How do I sum two columns counting duplicates between the two columns as one? Is this a countif?

Thank you,
Nate

	A	B	C	D
1			A	B
2	Total=7		1	0
3			1	0
4			1	1
5			0	1
6			0	1
7			0	0
8			1	0
9			1	1

<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[JoeMo]

Assuming your values are either 0 or 1 for both columns:

Excel Workbook
	A	B	C	D
1	1	0		7
2	1	0
3	1	1
4	0	1
5	0	1
6	0	0
7	1	0
8	1	1
Sheet1

 

[NHagedorn]

Awesome. Works great. What if I wanted to add an additional criteria? Red

Thought I could figure it out, but no luck.

Thank you,
Nate

CellFormula D1=SUM(A1:B8)-SUMPRODUCT((A1:A8=1)*(B1:B8=1))

	A	B	C	D	E	F	G	H	I
1	1	0	red	7			blue		5
2	1	0	red				red		2
3	1	1	blue
4	0	1	red
5	0	1	red
6	0	0	blue
7	1	0	blue
8	1	1	red

<tbody>
</tbody>

 

[NHagedorn]

=SUMIF(C:C,"Red",A:A)+SUMIF(C:C, "Red",B:B)-SUMPRODUCT((A:A=1)*(B:B=1)*(C:C="Red"))

Better, Cleaner way?