I was able to get what I needed by using the function you gave me. I
was really wondering if there was a way to use a vba code to do it.
Unfortunately, every time I open the workbook, it freezes, I guess
because it is doing too much work, accessing 5 other workbooks, and
returning the information for 2000 records.
This workbook is going to get larger so if there is no code to use
then maybe I'll just have to have 18 workbooks, 5 original, 12 -one
for each month-and one for the result formulas. This seems like way
too much work.
If you have any suggestions, I'd appreciate anything you could give
me.