Find Last data in a column
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
|