View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default 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