View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
drumz drumz is offline
external usenet poster
 
Posts: 17
Default How to get last amount in a column

I have formulas across a sheet with the total being in the last column
(Total). I want to put the total in the header of the page because of the
width. I thought I could just do =(t3:t200) but that doesn't work and of
course =sum adds so that won't do it either. How do I put in a range so it
will look at the last entry and bring those results?
Thanks!