Hi all-

I have been brought in to alleviate human error in counting the total monthly tool repairs entered into a spreadsheet.
In the whole workbook, I have tabs corresponding to all letters of the alphabet plus frequent customers (30 sheets in total). This is used for documenting the tool repairs we take in and then send out by putting the date in, in one column, and the date out, in another.
My goal is to total all of the dates-in and all of the dates-out on a TOTALS sheet to get our monthly repairs in/out totals.

As of now I have columns with the first (column J) and last (K) dates of the month for the criteria in the formula. The dates-in are in column B and I have renamed them all as: DATE_IN_1, DATE_IN_2, etc.
I have already successfully done this for our 4 largest customers using:
=SUMPRODUCT((ATMI!$B$2:$B$603>=J2)*(ATMI!$B$2:$B$603<=K2))
(ATMI is one of the 4 largest tool repair customers)

I want to recreate this formula so that it counts not only ATMI and the 3 other sheets, but all 28 other sheets in the workbook.
The problem is that the formula I currently have for each month does not count all of the dates in all of the worksheets.

The file is here:
TOOL REPAIRS.zip

Thanks in advance for the help