View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Jen S Jen S is offline
external usenet poster
 
Posts: 1
Default I need to show the last number in a rows in the total pending row

I have a column where I list pending cases each month and I need to show the
last number in the total pending cell at the bottom of the row. I can use an
offset fomula which works if the pending cases begin in row 1. However, I am
not able to get it to work if the pending cases begin in rows 4 or 5 as an
example. Any suggestion?