=LOOKUP(2,1/(D1:D65535<""),D:D)+LOOKUP(2,1/(Sheet2!E1:E65535<""),Sheet2!E:E)

In XL2007

=LOOKUP(2,1/(D:D<""),D:D)+LOOKUP(2,1/(Sheet2!E:E<""),Sheet2!E:E)



"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