ExcelBanter - View Single Post - Help Excel Data manipulation Pros: Something like a Vlookup with a Sum Function

Thread: Help Excel Data manipulation Pros: Something like a Vlookup with a Sum Function

View Single Post

#3

Report Post

Posted to microsoft.public.excel.worksheet.functions

excelent

Posts: n/a

Default

Help Excel Data manipulation Pros: Something like a Vlookup with a

=SUMPRODUCT((Sheet2!$A$1:$A$8=Sheet1!A1)*(Sheet2!$ B$1:$B$8))

Reply With Quote

Reply With Quote