Column progressing by change in one reference cell

Hi

I have a cell, D3, that sums up a day's change in other cells, rows etc, and would like to chart the development of D3's daily changes, probably as presented by a nearby column (or row) - without having to type/copy the different values by hand, one by one down the column.
The question is: How does one make a simultaneously progressing column, for example from E4 and infinetely downwards, with a new cell filled for each change in D3 (Day 2 turns up in E5, Day 3 in E6, etc)?
Any macro solution is no option, I'm afraid. The solution, I reckon, would be some kind of formula to be copied and swept down the E column.
That formula I should really like to see.
Hope someone knows it.

Thanks in advance
BCB

You can chart a named range that can by formulas increase each day or when a new value is added below it. if you are not using macros a formula updates so the value in d3 can not be captured by formulas as when it changes the formulas change. if you copied the value or typed the value at the end of the list this could be done. But if you do not want macros to automate this is impossible

Regards

Dav

No getting around the dreaded macros, eh? Well, I thought as much, although my Excel knowledge is too limited for me to know whether I'm asking for the moon or utter banalities.
Thanks anyway, for saving the time I'd have wasted trying to combine the formulas I know.
bcb

Sorry, Mr Hessey

The macro solution is not an option for me yet.
But thanks anyway
Bcb

How would Excel know which days which values are for?

I.E. is there a date corresponding with anything there? or is it counting the dates?

To get excel to sum the values of a column with a definitive start but no end would maybe be to do this...
=SUM(INDIRECT("E4:E"&3+COUNT($E:$E)-COUNT($E$1:$E$4)))

However if you need to break it out by date, there needs to be something signifing the date each number is there that some how corresponds. I.E. a date for the change in column F that corresponds? Then the formula would look like..

=SUMIF(INDIRECT("F4:F"&3+COUNT($F:$F)-COUNT($F$1:$F$4)),<Date>,INDIRECT("E4:E"&3+COUNT($E:$E)-COUNT($E$1:$E$4)))

So if you had the dates listed in the order in say column C
9/20/2006 (=NOW())
9/19/2006 (=C4-1)

You could have the formula read..
=SUMIF(INDIRECT("F4:F"&3+COUNT($F:$F)-COUNT($F$1:$F$4)),C4,INDIRECT("E4:E"&3+COUNT($E:$E)-COUNT($E$1:$E$4)))

Hope that helps in someway.
John

(Also if there are no values above row 4, you could just select $E:$E like that, rather than the indirect stuff I did)

Hello, again

davesexcel: I have no formula - yet. Judging by the words of Mr. Dav above, it seems impossible without a macro being created.

kraljb
Thank you for the suggestions. I'll copy them and try them out, although there will have to be some tweaking done, and I'm not too optimistic about it (for the same reason I gave davesexcel above).
To your first question: Excel wouldn't know of any date. It would, however, if it were fed the right formula, add a new cell per change in the reference cell, D3, downwards a neighbouring column.
The reference cell is a (statistical) result of another set of columns etc, that changes almost daily.
But no dice without the macros, it seems.
Thanks anyway
BCB