Why not something like:

=SUM(T3:T5000)

or some other large number which is beyond the rows that you are using
now?

Hope this helps.

Pete

On Nov 25, 8:42 pm, drumz wrote:
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!