Help with adding pages
 

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....

Help with adding pages
 

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

"Corey" wrote in message ...
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....

Help with adding pages
 

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)

--

Regards
Roger Govier

"Corey" wrote in message
...
Forgot to mention.
The ENTER-EXIT PAGE is the name of page 1.

"Corey" wrote in message
...
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....