Need a formula to calculate running anticipated total for a Month to Date report

[GreyedOutJedi]

Hello,

I have a spreadsheet where I have daily stats entered on individual worksheets including the number of hours an employee is scheduled to work and the hours they actually work. I then get a percentage of the hours they were anticipated to work.

I also have a Month To Date (MTD) page that sums the stats and gives results for stats like calls/hour or tasks/hour for the month as a running total.

I am having trouble getting a formula that will keep a running total of the anticipated hours. I don't want to enter the anticipated hours every day. They are entered at the beginning of the month and I'm trying to automate my report as much as possible.

I think it's similar to a SUMIFS, [equalsSUMIFS('PAGE1':'Page23'!,(lessthanToday)), obviously wrong, but I hope it gives you an idea], but I can't get it to sum the individual cells on 20-23 pages (Pg1=1st work day of the month, Pg2=2nd work day of the month, etc.) while not counting hours that are expected to be worked today or in the future that are already entered on the pages.

Is this maybe solved by an array or something other than just a simple formula?

Thanks in advance.

[Hercules1946]

A lot depends on how your data is arranged, so I would suggest that you post an example of your sheets, including expected results/totals t give us a better idea of what you need.

[GreyedOutJedi]

MTD Report Example.jpg

The report is structured so that each page has the same construction as the example and pulls the data from the same cell in each page.

For simplicity sake, page 1 is just '1', page 2 is '2', etc.(minus apostrophe's).

It's that next to bottom row that I'm having trouble with. Right now it just sums all 23 pages. I would like it to sum pages 1-yesterday's page.