Formula only calculating sum from first page, not universally through workbook

I have inherited a workbook which I have been asked to enhance. My excel experience is not stellar, far from it but as with my things I like to give it a fair shot.

I have a checking in workbook that calculates the movements of stock throughout the day. The workbook allows me to record when I receive stock and calculates how much stock passes through each hour and records this in a cell at the bottom of the sheet. However when I move to the 2nd page it does not continue adding to the totals at the bottom.

For instance, this formula is in one of the bottom cells that collects the data and adds it all up.

=SUMPRODUCT(--(timein>=0.875),--(timein<=0.961),cases)

Why wouldn't it apply to the entire sheet?


I have read the forum rules and apologise if I have fallen foul of them. I would appreciate any help as I am just starting to learn excel myself.

Sorry, to clarify I mean to scroll down beyond what would a A4 sheet. I have looked into the names and it does indeed seem that it has been defined to only work for the cells on the first page. How could I extend it down? There are titles separating the cells needed so would I have to extend the formula with an , and add the cells between? The worksheet is laid out 500 cells down

Cases was = ='DEL-DOC'!$F$3:$F$25

Thank you for your help.

The titles are part of the formula as when I rearrange the formula to start within the cell directly underneath where I input the numbers the formula breaks down. So I would then need to extend the range of the name cases, but when I do that, even to one more page, again the formula breaks down. Am I missing something or is it because there is more than one variable that I need to change along with the name?


Also, I cannot see timein on the name manager, only cases. Is timein an integrated part of excel in this case?

Thank you, I will post a copy tonight.