What do you think the function SUM() is doing for you the way you've tried
to use it?

Why not just =(R3+D3)-(F4+H4+J4+L4+N4+P4) ?
Or, if you prefer, =SUM(R3,D3)-SUM(F4,H4,J4,L4,N4,P4)

You've used the SUM function with only one argument, which is as pointless
as supplying only one argument to functions such as MIN, MAX, AVERAGE,
MEDIAN, PRODUCT, etc.
--
David Biddulph

"drumz" wrote in message
...
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!