Match formula

[Jim]

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

 

[Mike H]

Jim,

This would go on Sheet 2 referencing the unique email addresses in column A

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

Drag down as required

Mike

 

[Mattlynn via OfficeKB.com]

You could create a pivot table instead, that would sum by email address the
values.

 

[muddan madhu]

use this formula in sheet2 cell B1

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