Running Total from previous page

[Guest]

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.

 

[davesexcel]

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

 

[Biff]

Hi!

Try this:

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

Change the sheet reference as appropriate.

Biff

 

[Guest]

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

Thanks

 

[Biff]

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

 

[Biff]

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

 

[Aladin Akyurek]

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.