use this formula in sheet2 cell B1

=SUMIF(Sheet1!$A$1:$A$4,A1,Sheet1!$B$1:$B$4)



On Oct 22, 6:50*pm, Jim wrote:
Hello,

Thanks in advance for the help. *

Worksheet One - I have email address listed in column A with dollar amounts
listed in column B. *These emails are listed multiple times, with different
amounts each time the email is listed.

Worksheet Two - In column A, I have the email listed once. *I would like to
match the email from worksheet Two to all the occurrences in worksheet one
and sum the dollar amounts from column B.

Again, thanks for the help.
Jim