rebeccafpc
New Member
Hello
I am trying to link a Master daily sales commission report that is fairly easy and the Sumif function works but not when the workbook is closed. I have tried Vlookup but does not work. Here is the formula that works when open : SUMIF('F:2012 COMMISSION SHEETSD''ANN[D''ANN COMM SHEET.xls]JAN'!$B:$B,"Jan2",'F:2012 COMMISSION SHEETSD''ANN[D''ANN COMM SHEET.xls]JAN'!$D:$D)
I need to be able to report each day commission amount for about 10 sales people. They all have a seperate workbook and I want it to total each day on the master workbook. Extract the day and month and the sale amount total for that day.
I am trying to link a Master daily sales commission report that is fairly easy and the Sumif function works but not when the workbook is closed. I have tried Vlookup but does not work. Here is the formula that works when open : SUMIF('F:2012 COMMISSION SHEETSD''ANN[D''ANN COMM SHEET.xls]JAN'!$B:$B,"Jan2",'F:2012 COMMISSION SHEETSD''ANN[D''ANN COMM SHEET.xls]JAN'!$D:$D)
I need to be able to report each day commission amount for about 10 sales people. They all have a seperate workbook and I want it to total each day on the master workbook. Extract the day and month and the sale amount total for that day.