But you didn't say anything about dates or other columns in your original post?

"Steve" wrote:

Thanks Toppers, the LOOKUP function works very well, but the INDEX function
gave quite varying results, sometimes the 3rd last or the 5th last in an date
column (A), and nothing in columns with numbers , currency (F) or percentages.

I came up with my own, slightly more complicated function,
LOOKUP(MAXA($A$4:$A$53),$A$4:$A$53,F4:F53), which not only finds the last
date, but uses that to return the value on that date.

But anyway,
Thanks for your reply,
--
Steve H


"Toppers" wrote:

If there are NO blank entries in the columns then

=INDEX(A:A,COUNTA(A:A)) will give las entry in column A

If there are blanks then:

=LOOKUP(99^99,A:A)

this will sum last entries in columns A & D

=SUM(LOOKUP(99^99,A:A)+LOOKUP(99^99,D:D))

or simply

=LOOKUP(99^99,A:A)+LOOKUP(99^99,D:D)

HTH


"Steve" wrote:

I am trying to get Excel to sum the last entry in a column in one worksheet
with the last in another worksheet. The last entries may not be either Max or
Min values, but the last entered, by the way, these values are the result of
a calculation in the sheets.
Can anyone help?
--
Steve H