still stuck (value of a cell in a different location)

still stuck, i hope someone can help us out! please!

cell d (best date to sell) shows us the best date to sell
the price we sell for is cell c (my sell price)
we want to show "my sell price" on "best date to sell"

for example:
------
on 100701, bought for 2086, need to sell for 2190, the best date to sell would be 100708.

on 100708 in column E we want the value of 2190. (cell E9)
------
on 100703, bought for 2085, need to sell for 2189, the best date to sell is again 100708.

there is already the value of 2190 in E on 100708 so we need to add 2189 bringing the total of E9 to 4379
------
on 100702 there is no best date to sell so E3 will equal 0

Funny , I am pretty sure I understood what he wants.

Try this in cell "E2"

=SUMIF($D$2:$D$9, A2, $C$2:$C$9)

Then drag and copy down.

Hey Marvin,

Actually, you know a lot more about excel than me and can teach me quite a lot, I am way below the level of understanding of excel than you.

The way Interpreted this was, that the "A" column was fixed as being dates, continuous of corse. And the "bought price" column, the OP is entering manually. I also am interpreting that the "my sell price" column is entered manually.

So that leaves the "best date to sell" column and column "E". Since he wanted a formula to to add up the data when he has input which day is best to sell, the SUMIF formula is all that was needed I thought. He wanted a formula to add data that corresponded with the predetermined "best sell" dates, that the OP has seems to have stipulated.

I don't think he is looking for a formula to determine which is the best dates to sell? That how I see it anyway.

As to why summing the Sell Prices for the Sell dates based on a match of Buy Dates makes any sense, I guess the OP could enlighten us a bit more, b/c I find confusing too. Unless this is just a table to record his data as it happens and nothing more?

But I do understand what you are saying.

Also, when you said "From the first post is says you want the value of 2190 in E9 - I'm lost at this point." He also said that another piece of data "2189" that falls on the same best sell date and b/c there is already 2190 in cell E9 , he needed a formula to add those peices of data that fell on the same date.

To the OP, could you elaborate a bit more for us? Or is the formula what you were looking for?

at 12:30am the train was not moving....

Correct!
12:30 is an instant in time, Therefore nothing moves!

I apologise for my humble pie, was it not to your taste? Was it offal?

Joking apart I'm glad your problem has been solved, and regret I was not sober enough to see your question clearly when I posted.

Well done JapanDave