I have tried to search this site and web for possible solutions without success. I am needing to use a combination of a vlookup with a sumifs formula that works between two workbooks as well as potentially two or more worksheets within one of the workbooks. The formula below works well if I'm using it to look at one worksheet.
But... if I want to use this formula to look at two worksheets in one workbook in combination with the vlookup I get a #Value. I'm hoping someone will be able to look at this and see what I'm doing wrong. I wish I could post a sample workbook(s) but it would be very difficult. Any suggestions to fix the following formula would be greatly appreciated!
edited to add: I forgot to mention the sumifs portion is looking for data between two dates.