Thread: HELP! Need formula that will pull data from one workbook to another

Hello,

I was wondering if anyone could help me with the following:

I need to pull data from one workbook (DATA) to another workbook (STATS) within an excel spreadsheet.

The data I require is:

All dates (REQ OPEN) that fall between September 1, 2011 and September 30, 2011 and among those dates which of them include a 1 from column (PR). The answer in the end would be 51 if I use the filter, but a formula would be alot more help. I have attached the spreadsheet as well.

Please help!!!!