count use of a value in several files?

[rwhitlock]

I hope I can explain this right:
I have many Excel files, each represents one episode of a TV show. The files list info on all the music clips in the show. (CD title, track number, track title, composer, etc. in order of use.)
I want to be able to look at all the Excel files (or those dated within a certain range) and see how many times each music track has been used in all the episodes.
So I can say, for example, in all the episodes in the last two months we've used the song "Neon Lights" 68 times.
I have FileMaker Pro, if I can import the files into that to do what I want, that will work too.
Thanks,
Randy

[robert111]

Please explain further, is an excel file a workbook, or a sheet within a workbook. Assuming the former, a sumproduct formula would work. Assuming date in column A and song title in column B, and you want to know how many times jingle bells was played between Dec 1st and Dec 25...

=sumproduct((tunes1.xls:sheet1!$a$1:$a$1000>"Nov 30")*($b$1:$b$1000="jingle bells"))-sumproduct((tunes1.xls:sheet1!$a$1:$a$1000>*Dec 25")*($b$1:$b$1000="jingle bells"))

You will need to expand this for EVERY file, I would recommend exporting your data to Access....