Help with adding pages

[Corey]

I have a fomula [=MAX('Enter-Exit Page:9'!J59)] that gives me the MAX value of the values in Cell
J59 in each sheet in a workbook.

The formula aboves works great up until page 9, but if there is 20 pages and i have page 10 active,
i ONLY get the MAX value up until page 10 and it will not include pages 11-20.

Is there a LAST PAGE formula or some way i can change the formula to show the Max value of ALL
values in ALL sheets in J59 ?

Hope i am explaining it correctly.


Corey....

 

[Corey]

Forgot to mention.
The ENTER-EXIT PAGE is the name of page 1.

I have a fomula [=MAX('Enter-Exit Page:9'!J59)] that gives me the MAX value of the values in Cell
J59 in each sheet in a workbook.

The formula aboves works great up until page 9, but if there is 20 pages and i have page 10 active,
i ONLY get the MAX value up until page 10 and it will not include pages 11-20.

Is there a LAST PAGE formula or some way i can change the formula to show the Max value of ALL
values in ALL sheets in J59 ?

Hope i am explaining it correctly.


Corey....

 

[Roger Govier]

Hi Corey

Create 2 dummy sheets and call them First and Last.
Drag them so that they "Sandwich" the set of your sheets then use the
formula
=MAX(First:Last!J59)