• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help With Sum If function

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.
 
Unfortunately, SUMIF, as you found out, does not work on external links/workbooks. You'll need to first bring in all the data, using either a simply link like

=Book2!A1


or setup an data query to query the other workbook(s).
 
Hi Rebecca ,


This issue has been documented in the Microsoft Knowledge Base , where they have suggested some workarounds. Can you check out the following link ?


http://support.microsoft.com/default.aspx?scid=kb;EN-US;179029


Narayan
 
Back
Top