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.