Copy last entry of column to bottom of column

[jimmy_v_12]

I am using a simple formula to keep track of some stocks, i.e. D2=Sum(B2*C2).
This formula is repeated in rows 2 thru 31. In cell D34 I want to display
the last previous entry in column D.

Thank you for your assistance.

 

[David Biddulph]

Why the SUM function?
What do you want to add to B2*C2?

 

[T. Valko]

Not sure I underatand what "last previous entry" means.

See if this does what you want:

=IF(COUNT(D231),LOOKUP(1E100,D231),"")

 

[Sean Timmons]

=LOOKUP(9^99,D231)

will return the last value

 

[Mike H]

jimmy,

I'm not sure I understand but try this in D34

=LOOKUP(2,1/(D231>0),D231)

Mike