Here a couple of things that you might want to consider. I have a different layout of the calculations with the months going down columns and the totals arranged across. I am not clear on whether or not you want the 3 columns totalled together or separately for each month so I have given you both the total for all three columns for weekdays and weekends for the three columns for each month and the totals for each column for weekdays and weekends for each month. This is set up to handle 10000 rows of data.
Dates for both workbooks are set up in columns G and H
Sample formula without named ranges. This calculates all weekdays for January for all columns:
In the second workbook I have used the same arrangement but have added dynamic named ranges and the output in a table that will total the named ranges as data covering additional months is added to columns A to D. This is set up for 10,000 rows. As a month is added to the data, just click on the last cell of the table (lower right) and hit the tab key. A new row already populated with the calculations will be added.
This formula is the same calculation as above in the file with named ranges:
Bookmarks