How to "return the last value entered in a column"?

[OceanCarl]

Folks,

I have a spreadsheet with two colums were new values are entered every day. On the bottom of theese colums I want to be able to see the sum of the last to values entered. How can I make this go automaticly? My teori is to make the last sum entered in each column appear in two cells, and then sum theese to cells. But I can't seem to find a function that works for this. I've tried the "IF" function, but I can only make it work on two cells on a row (=IF(A9;A9;A8)) (I want it to go all the way up to A1)

Thanks in advance

[VBA Noob]

Hi,

This link should help

http://www.xldynamic.com/source/xld....l#last_numeric

You can add the two formula's to get the total

VBA Noob

[VBA Noob]

or

=INDIRECT("A"&COUNTA(A:A))+INDIRECT("A"&COUNTA(B:B))

VBA Noob

[OceanCarl]

Thank you for your answer. But it seems like the formulas given depends on the last input to be a higher value then the one above. This is not the case in my problem since the daily inputs might have a lower value than the one the day before.

But I found a sollution to my problem myself . Using the "IF" function, and editing the function with another "IF" function within the first function. It seems to work for me

=IF(C12;C12;(IF(C11;C11;(IF(C10;C10;(IF(C9;C9;C8)))))))

Edit: However, it seems only to work with up to 9 cells.... Hmmmmm

[starguy]

Thank you for your answer. But it seems like the formulas given depends on the last input to be a higher value then the one above. This is not the case in my problem since the daily inputs might have a lower value than the one the day before.

But I found a sollution to my problem myself . Using the "IF" function, and editing the function with another "IF" function within the first function. It seems to work for me

=IF(C12;C12;(IF(C11;C11;(IF(C10;C10;(IF(C9;C9;C8)))))))

Edit: However, it seems only to work with up to 9 cells.... Hmmmmm

can you attach a sample file for proper consideration and to make a formula for your purpose.

[OceanCarl]

can you attach a sample file for proper consideration and to make a formula for your purpose.

It don't seem to be possible to attach a Excel document, but here's a screenshot of an example file..

[starguy]

It don't seem to be possible to attach a Excel document, but here's a screenshot of an example file..

try this for stock x

=VLOOKUP(LARGE($B$7:$B$41,1),$B$7:$D441,3,FALSE)

[VBA Noob]

Try

=OFFSET($D$7,COUNTIF(D7:D41,">0")-1,0)

VBA Noob

[vane0326]

Do you want to sum the last values in column D & H? If so input formula in cell F44


=LOOKUP(10^307,D:D)+LOOKUP(10^307,H:H)

[VBA Noob]

I tried it and it will return zero.

If you check his example he has zero down to row 41.

VBA Noob

[vane0326]

I tried it and it will return zero.

If you check his example he has zero down to row 41.

VBA Noob

Hi VBA Noob,


Really I tried it and I get the sum value or am I missing something.

[davesexcel]

excel tips link

http://www.exceltip.com/st/Find_the_...Excel/607.html