How to get last amount in a column

  • Thread starter Thread starter drumz
  • Start date Start date
D

drumz

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!
 
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
 
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!
Click to expand...

=LOOKUP(9.9999E+307,1:1) will return the numeric entry in the last column with
numeric data in row 1.

If you want the number in the last ROW of column T, then

=LOOKUP(9.999E+307,T:T)


--ron
 
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.
 
Ron, I substituted the "t" with an "r" since that's where I have the formula
totalling now. But when I tried yours it gave me an error. Here's the formula
I use down the column "R" so the formula in R4 is
=SUM(R3+D3)-(F4+H4+J4+L4+N4+P4) and on down the page. I want to put the
results in a cell at D1. I could just =R130 but I thought there is probably a
more elegant way to do it.
 
Ron, I substituted the "t" with an "r" since that's where I have the formula
totalling now. But when I tried yours it gave me an error. Here's the formula
I use down the column "R" so the formula in R4 is
=SUM(R3+D3)-(F4+H4+J4+L4+N4+P4) and on down the page. I want to put the
results in a cell at D1. I could just =R130 but I thought there is probably a
more elegant way to do it.
Click to expand...

What do you mean "it gave me an error". Excel can generate many different
kinds of errors, and it's almost impossible to trouble shoot if you don't
provide that.

Perhaps you're using the wrong separator?
--ron
 
Sorry for not being clear it wasn't an error but more of me not explaining
better what I wanted to do. I'm just going to use the last cell in the column.
Thanks for your time though!
 
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.
 
Back
Top