AVERAGE / OFFSET FUNCTIONS, TODAY..

[Guest]

I have an equation can't quite figure out. Will take advice on how to setup
if I am on wrong track. Trying to get a running average over a 2 day period
(if can? using same 2 cells for each subsequent day for input, in same row).

For now example is in column format.
cell E4, enter number: 2
cell E5, enter: =AVERAGE(OFFSET(B5,-E$4+1,0,E$4,1))
and drag down a few rows.
in cell B5 "down", can put sequential numbers: 1, 2, 3, 4...

The above works as intended. What I need is to only use 2 cells in "B"
column, so equation only goes back 1 day? you get it..

Equation dragged down shows 3 results, before #DIV/0!
Example: need to put Input for, monday, in 1st cell (B5), tues in cell B6,
BUT wed uses cell B5. Is that possible?
Result needed is for a 2 day average: "Up" or "Down" to show in 1 cell.

Don't know where to start on equation. Do I need something like TODAY(), or
will a minus 1 somewhere work..
Other idea was a 5 day & WEEKDAY / WORKDAY, would be nice to figure out, but
may be more days than can use now.
Thanks for Help...

 

[RagDyeR]

What am I missing here?

If you're going to continually use *only* B5 & B6, alternating between them
each day,
What's wrong with:

=AVERAGE(B5:B6)

If you're entering data all the way down Column B, one cell per day,
The exact, same formula, copied down Column E, would *still* give you 2 day
averages,
consecutively.

Care to elaborate on your question?
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

I have an equation can't quite figure out. Will take advice on how to setup
if I am on wrong track. Trying to get a running average over a 2 day period
(if can? using same 2 cells for each subsequent day for input, in same row).

For now example is in column format.
cell E4, enter number: 2
cell E5, enter: =AVERAGE(OFFSET(B5,-E$4+1,0,E$4,1))
and drag down a few rows.
in cell B5 "down", can put sequential numbers: 1, 2, 3, 4...

The above works as intended. What I need is to only use 2 cells in "B"
column, so equation only goes back 1 day? you get it..

Equation dragged down shows 3 results, before #DIV/0!
Example: need to put Input for, monday, in 1st cell (B5), tues in cell B6,
BUT wed uses cell B5. Is that possible?
Result needed is for a 2 day average: "Up" or "Down" to show in 1 cell.

Don't know where to start on equation. Do I need something like TODAY(), or
will a minus 1 somewhere work..
Other idea was a 5 day & WEEKDAY / WORKDAY, would be nice to figure out, but
may be more days than can use now.
Thanks for Help...

 

[Guest]

Hi! thanks. If average works, may be simple answer. Equations new for me..
maybe getting caught up in them.. will need to know if 2 days prior average
is less or more than todays output.. sounds like that will work ha.. thanks..