Sum IF Duplicate Value in New Column Without Consolidation

[Jguidry05]

I am struggling with a datasheet that has the results of every email campaign I have run. It Contains columns:

EMAIL

NAME

COMPANY

OPENS

TITLE

LIST

Email List

<tbody>
</tbody>

Email addresses appear on the sheet based on their presence on the email results, so many email addresses appear multiple times. I dont want to eliminate the duplicates, or consolidate them, they serve a purpose for me to reference the email with which they opened and its corresponding stats. I am trying to rank email addresses (openers) By their AVG which I have taken from 2 Columns I added: # of Emails opened, and Times Opened (Sum of "Opens" Column above for each corresponding email address for each email they opened)

I would like to find a conditional formula/function to take the sum of each "OPEN" IF there is a duplicate email address without consolidating the duplicates.

So far I have been doing the math by hand and using formulas/functions for the "Times Opened" and "AVG"

EMAIL	NAME	COMPANY	OPENS	TITLE	LIST	Email List	Times Opened Emails	# EMAILS OPENED	AVG
13IEUPS@BELLSOUTH.NET	PEGGY SEGURA	PEGGY SEGURA INC	1	Owner	infoUSA	MSSP Combined Lists Linkedin and InfoUSA		1
GLENRAY@COX.NET	GLEN RO\AY	GLEN WELL SVC INC	1	Manager	infoUSA	MSSP Combined Lists Linkedin and InfoUSA		1
MRFENCE@COX.NET	ALDEN TRENT	MR FENCE	1	Manager	infoUSA	MSSP Combined Lists Linkedin and InfoUSA	2	2	1
MRFENCE@COX.NET	ALDEN TRENT	MR FENCE	1	Manager	USA	MPS 30% Off -USA List	2	2	1
AALBERT@FNB.COM	ARLENE ALBERT	FIRST NATIONAL BANK	1	Executive Officer	USA	MPS 30% Off -USA List		1

<tbody>
</tbody>

 

[Jguidry05]

I found the solution using the SUMIF= Formula. It did exactly what I needed it to.
=SUMIF(A$2:A$2709,A2,D$2:D$2709)
Dragged down to copy and worked like a charm.