SUMIFS, multiple criteria incl. unique values

Granted, I have found several formulae that are meant to solve this sort of problem, but as much as I fiddle with it to match my context I can't seem to get an elegant solution. Nor any solution, actually.

Consider five columns:

Name	#	Type	Value	Activation
James	0	type1	200	1
James	1	type3	2	0
James	2	type1	400	0
James	3	type2	40	1
John	0	type1	200	1
John	4	type3	4	1
John	2	type1	400	1
Caitlin	3	type2	40	1
Caitlin	5	type1	200	1

The "Name" column isn't really relevant, but it illustrates why I don't have unique values for column "#". Of the values in the "Value" column, I want to sum those that meet the following criteria:

1. "Type" = type1
2. "Activation" = 1
3. The value in "#" is unique (i.e. no double addition).

So only the second, eighth and tenth rows satisfy the above, returning a sum of 800. Obviously, I'd like the formula to work for a range of values, specifically {type1, type2, ... , typen} for "Type" and {0,1} for "Activation." As long as values with the same "#" aren't summed twice then I'm happy. Until I ran into the double-addition issue I was using this formula, seemingly successfully:

=SUMIFS(Value,Type,"type1",Activation,1)

I've posted this same question here and here. Help would be appreciated.