Another way to write the formula that isn't so hard to understand is:

=LOOKUP(MAX(C:C)+1,Sheet1!C:C)

Ooops!

Should be:

=LOOKUP(MAX(Sheet1!C:C)+1,Sheet1!C:C)

Biff

"Biff" wrote in message
...
I don't understand what 9.999999999E+307 means.

Don't feel bad, not too many people do!

That is the largest number that can be entered into a cell. The way Excel
performs lookups has a "bug" and this formula takes advantage of that bug.

Since there is no chance that the number you're looking for will be even
remotely close to 9.999999999E+307, the lookup returns the last numerical
value in the range that is smaller than the lookup value.

Another way to write the formula that isn't so hard to understand is:

=LOOKUP(MAX(C:C)+1,Sheet1!C:C)

Biff

"Vanna" wrote in message
...
Hi Biff,
Thanks for your reply. Your formula works perfectly. I don't understand
what 9.999999999E+307 means. Can you explain?

Thanks

"Biff" wrote:

Hi!

Try this:

9.999999999E+307
Change the sheet reference as appropriate.

Biff

"Vanna" wrote in message
...
I need a running total for the previous page...

I have a spreadsheet..say column A contains user entry date. Column B
contains prices and column C contains the formula =if A3<"",
C2+B3,"").
This formula is copied to the rest of the column.

I would like to take the last running total to the next page so I can
carry
on with other calculation. How do I write this formula?

In advance thank you for your help.