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!

How to get last amount in a column
 

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!

How to get last amount in a column
 

On Sun, 25 Nov 2007 12:42:00 -0800, 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!

=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

How to get last amount in a column
 

try this idea
SUM(t3:OFFSET(t3,MATCH(999999,t:t),0))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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

How to get last amount in a column
 

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!

How to get last amount in a column
 

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 Rosenfeld" wrote:

On Sun, 25 Nov 2007 12:42:00 -0800, 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!

=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

How to get last amount in a column
 

On Sun, 25 Nov 2007 14:06:01 -0800, drumz
wrote:

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.

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

How to get last amount in a column
 

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!

"drumz" wrote:

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 Rosenfeld" wrote:

On Sun, 25 Nov 2007 12:42:00 -0800, 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!

=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

How to get last amount in a column
 

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!