Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT help
Column A - name of the person. for example John Smith.
Column B - Primary ID JSMITH Column C - Secondry ID JSMITH2 Column D needs to look for Primary and Secondry IDs in another workbook column A and return the sum of the corresponding values in column D. so other workbook A1 - JSMITH. A5 - JSMITH2 D1 - 15 D5 - 25 so i need the formula to return 40. thanks in advance for any help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT help
well...SUMIF worked.
thanks for going through the post though. :) "Gaurav" wrote in message ... Column A - name of the person. for example John Smith. Column B - Primary ID JSMITH Column C - Secondry ID JSMITH2 Column D needs to look for Primary and Secondry IDs in another workbook column A and return the sum of the corresponding values in column D. so other workbook A1 - JSMITH. A5 - JSMITH2 D1 - 15 D5 - 25 so i need the formula to return 40. thanks in advance for any help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT help
Formula in cell D1 on first sheet:
=SUM((([SecondWorkbookName]SheetName!$A$1:$A$200=B1)+([SecondWorkbookName]SheetName!$A$1:$A$200=C1))*[SecondWorkbookName]SheetName!$D$1:$D$200) Array enter (Shift-Ctrl-Enter) "Gaurav" wrote in message ... Column A - name of the person. for example John Smith. Column B - Primary ID JSMITH Column C - Secondry ID JSMITH2 Column D needs to look for Primary and Secondry IDs in another workbook column A and return the sum of the corresponding values in column D. so other workbook A1 - JSMITH. A5 - JSMITH2 D1 - 15 D5 - 25 so i need the formula to return 40. thanks in advance for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
#VALUE! from SUMPRODUCT | New Users to Excel | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
Sumproduct help | Excel Worksheet Functions | |||
Sumproduct help | Excel Worksheet Functions |