SumIF? Reading values in a column

[vehloaaron]

Hoping someone can assist with a problem I think Excel can solve for. I have duplicate email addresses in a database, if one duplicate opts out, I need to find all matching emails and opt them out to. I think I could use a SumIF statement using a helper column that identifies the email as a duplicate, however I can't quite get it to work as I would like. Below is an example of what I am trying to do, column G - I are desired state.

OptOutTest.csv
	A	B	C	D	E	F	G	H	I
1	email	Duplicate	Email Opt Out 1	Email Opt Out 2	Email Opt Out 3		Email Opt Out 1	Email Opt Out 2	Email Opt Out 3
2	aaront@duplicate.com	1	TRUE				TRUE		TRUE
3	aaront@duplicate.com	1			TRUE		TRUE		TRUE
4	aaront@duplicate.com	1					TRUE		TRUE
5	Aaront@notaduplicate.com	0	TRUE				TRUE
OptOutTest

 

[johnny51981]

Give this a try in your Column G

=IF(COUNTIFS(A:A,A2,C:C,"TRUE")>0,"TRUE")