Pete, That just adds the contents of the column. The last column is a running
total. Here's the formula that would go in R4 =SUM(R3+D3)-(F4+H4+J4+L4+N4+P4).
R3 is the last total then D3 is a plus or minus and all the others are
again, pluses or minuses entered.

"Pete_UK" wrote:

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!