Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match formula
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match formula
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 "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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match formula
You could create a pivot table instead, that would sum by email address the
values. 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 -- Matt Lynn Message posted via http://www.officekb.com |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match formula
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help with match? I don't know what formula use | Excel Worksheet Functions | |||
match formula - 2 excel files:#1 hasthis formula, 2nd has the Raw | Excel Worksheet Functions | |||
How do I display more than one match in a Index/Match formula? | Excel Worksheet Functions | |||
MATCH Formula | Excel Worksheet Functions | |||
Lookup Formula - but have a formula if it can't find/match a value | Excel Worksheet Functions |