I am only using 1 workbook so I put the module into the workbook I am using, then I copied the formula and put it into the cell I'd like the information to show up in. The only change I made to the forumula was that I took out the "C:\My Documents\[Book6.xls]" before each range of cells. The raw data is in "Sheet1" of the workbook so I left that part in.

When I press Shift+Ctrl and then hit enter nothing happens.

Right now, the final output is just a blank cell.