sumproduct (link to another excel workbook)

[ronlau123]

Dear all,

Every week, I also receive the excel file (sourcefinal.xls), it is regarding account manager's sales summary.

I have another workbook called summaryfinal. xls. It includes sales summary of acccount manager. I know that I can use sumproduct formula to retrieve/get data from the sourcefinal.xls


In the sourcefinal excel, we have 4 types of product, od, fund, loan and mortgage. For loan and mortgage, it divided into number of product sold and total sales amount of the product. In the excel, we just need ytd, year to data data.

HOwever, I spend two hours, still can't fix it. Appreciate your help. Thanks