Reference a formula that is copied down the page

[acura123]

I want to be able to reference a formula so that when it is drug down the page it keeps the last value. So if for example the formula simply keeps a running total I want the other cell to reference the last total in the running total cell.

So if A1 is the Value

and c1:c3 is a running total with c3 equal to say $50.00 if c3 is drug down to equal a new value I want A1 to reflect that new total.


Any Ideals?

Thanks

 

[dave3009]

Could you not just reference the entire column

=SUM(C1:C65536)

Then as you add in values it will just total it up as you go.

You can adjust the range to suit your more specific needs.

KR


Dave

 

[acura123]

Won't work

Summing the column won't work because it gives me the total of the whole column not the running total amount. I just want the last value in the column.

 

[VoG]

Try

=INDEX(C:C,MATCH(0,C:C,-1))

 

[Aladin Akyurek]

I want to be able to reference a formula so that when it is drug down the page it keeps the last value. So if for example the formula simply keeps a running total I want the other cell to reference the last total in the running total cell.

So if A1 is the Value

and c1:c3 is a running total with c3 equal to say $50.00 if c3 is drug down to equal a new value I want A1 to reflect that new total.


Any Ideals?

Thanks

=LOOKUP(9.99999999999999E+307,C:C)

 

[acura123]

Found a web page on it

http://exceltips.vitalnews.com/Pages/T0530_Retrieving_the_Last_Value_in_a_Column.html


Thanks for the HELP

 

[Aladin Akyurek]

Re: Found a web page on it

http://exceltips.vitalnews.com/Pages/T0530_Retrieving_the_Last_Value_in_a_Column.html


Thanks for the HELP

The LOOKUP above is faster... and ignores empty/blank cells if any.