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.

Hi!

Try this:

=LOOKUP(9.99999999999999E+307,Sheet1!C:C)

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.

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:

=LOOKUP(9.99999999999999E+307,Sheet1!C:C)

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.

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.

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.

Biff wrote:
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.


That's a disturbing qualification even when between double quotes: It's
rather how a 'binary search algorithm' would proceed. OpenOffice Calc,
version 2.0, appears to be closing on the MS implementation of Match and
Lookup.

when you are on sheet2 column Cwhatever
hit = and go to sheet1 and click on the cell with the last running
total hit enter

I hope I understand the question correctly
:)


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=519044