I am using the following function to return a value from Column B if Column A meets certain criteria:
=SUMPRODUCT(--('Brian Chadwick.xlsx'!$A2:$A200>20130505),'Brian Chadwick.xlsx'!$B2:$B200)
This function is working correctly. However, I need to alter the function to test for a range of numbers. IE: >20130505 AND <20130513. I've tried several variations of the formula with no success. Can anyone help me?