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. |
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 |