Find last but one value in tabel column

**martindwilson** · 07-02-2014, 12:05 PM

=INDEX(Table8[Last DaySick], COUNTA(Table8[Last DaySick])-1, 1) perhaps

**welshman010** · 07-02-2014, 12:10 PM

Originally Posted by martindwilson

=INDEX(Table8[Last DaySick], COUNTA(Table8[Last DaySick])-1, 1) perhaps

Perfect. Thankyou

**welshman010** · 07-02-2014, 12:15 PM

Ho do i apply the same to a sumif formula.

=SUMIFS(Table8[Number 
of Days],Table8[Last Day
Sick],">="&C11,Table8[Last Day
Sick],"<="&B11)

Sum column bar the last one

Re: Find last but one value in tabel column